Get Involved. Join the Conversation.


    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
    Dymnaic account member with TwoPass enabled is giving #Missing for DTS
    Dymnaic account member with TwoPass enabled is giving #Missing for DTS

    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,




    • Amithkumar0206


      What is the formula you have against your dynamic member ?


    • 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


      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.

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