s Satoshi
on

 

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

Forums: Define.xml

c Chikaaki
on June 20, 2022

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

Thank you.

Chikaaki

s Satoshi
on June 21, 2022

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

c Chikaaki
on June 22, 2022

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

 

l Lionel
on August 11, 2022

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? :)

 

Thanks a lot in advance.

 

Lionel.

 

Trevor
on August 15, 2022

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

l Lionel
on August 18, 2022

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.

s Satoshi
on August 18, 2022

Hi, Trevor

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

Best regards, Sato

Want a demo?

Let’s Talk.

We're eager to share and ready to listen.

Cookie Policy

Pinnacle 21 uses cookies to make our site easier for you to use. By continuing to use this website, you agree to our use of cookies. For more info visit our Privacy Policy.