WhereClause is not displayed by Selection Criteria part of Analysis Results Metadata

I do not believe it is supported with P21 Community about ARM while it is creating define.xml.

Thank you.

Chikaaki

Hi, Mr.Chikaaki

Thank you very much for answering the question.
I hope that the malfunction is revised by next update of Pinnacle21C.

Best regards

Hi, Satoshi-san.

It is found that Community V4.x support ARM creation using P21C.

Please download the installation kit and use the template.

Thank you.

Chikaaki

Hello,

I’m experiencing the same issue. Where is located the template you mentioned ?

Because, everything else is filled correctly, but the Parameter section and the Selection Criteria.

How to complete that correctly ?
I’ve tried to use the ARM Define.xml from CDISC and convert it to Specification through P21 4.0.1. However the result is disapointing as the Selection Criteria column is empty and no Parameter to be found anywhere. I thought first to complete the WhereClause Column in the ValueLevel sheet, but there is no way to reference it in the Selection Critieria column of Analysis Result sheet.

A little help here? :slight_smile:

Thanks a lot in advance.

Lionel.

Hi,

I can verify that this is a bug in the latest version of P21C 4.0.x. I’ve created a ticket to have this fixed in the next release. This bug only impacts generating a define Spec from define.xml. Generating a define.xml from a define spec with values in this cell will work as expected. You’ll need to populate them manually.

Here are examples of how to populate this field:

  • A single dataset and complex where clause:
    • ADQSADAS[PARAMCD EQ ACTOT and AVISIT EQ “Week 24” and EFFFL EQ Y and ANL01FL EQ Y]
  • Multiple datasets and complex where clauses:
    • ADAE[TRTEMFL EQ Y and AESER EQ Y] ADSL[SAFFL EQ Y]

Please let me know if this works or if you have additional follow up questions.

Trevor

Product Manager

Hi Trevor,

Thanks a lot for your answer.

I made a mistake by assuming that “=” was equivalent to “EQ”. It was not the case, now it is replaced it is working just fine !

Thanks a lot for your time and help.

Kind regards

Lionel.

Hi, Trevor

I appreciate your replying my question.
According to your instruction, I was able to create ARM without a problem.

Best regards, Sato

Dear, Pinnacle 21 Staff

Even if I fill in Analysis Results Sheet with anything,
def:WhereClauseRef cord is not made at all in arm:AnalysisDatasets in Defien.xml.
Please instruct the entry example to the Excel Sheet.

Best regards, Sato