Essbase

Get Involved. Join the Conversation.

Topic

    Anushabatch10
    Dymnaic account member with TwoPass enabled is giving...
    Topic posted February 22, 2018 by Anushabatch10 , last edited August 1, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Reporting 
    31 Views, 3 Comments
    Title:
    Dymnaic account member with TwoPass enabled is giving #Missing for DTS
    Summary:
    Dymnaic account member with TwoPass enabled is giving #Missing for DTS
    Content:

    Hallo Experts,

     

    When I retrieve QTD against dynamic two pass enabled member I am getting #missing. Is it supported to query DTS on two pass enabled members?

     

    Thanks in advance,

    Anu

    Comment

     

    • Amithkumar0206

      Hi,

      What is the formula you have against your dynamic member ?

      Thanks

    • Anushabatch10

      Hello Amit,

      Thanks for the reply. I can not post the formula here as information is restricted.

      Basically the dynamic calc value is calculated based on a other dynamic calc member which comes later which comes later in the hierarchy. There is no issue with the calculation. 

      If I uncheck two pass,  DTS QTD returns value but unfortunately the calculated value is wrong at member level. We do need Two pas calc to get correct values.

      As per the dynamic calc order DTS members are calculated before Two Pass members. My query is that  Can we query DTS members against dynamic two pass calc?

    • ManojPavan Ch

      Hello,

      I am not sure why the value is showing #Missing.

      At least by the calculation order it should give you a first pass value since two pass member is calculated after Time series members.

      https://docs.oracle.com/en/cloud/paas/analytics-cloud/adess/calculation-order-dynamic-calculation.html

      This looks like a bug to me and try logging SR with replicable case.