How do i write an MDX query to accomplish the following -
MbrVal = MbrVal --> No_Entity --> No_Company --> No_Product -->&CurrDay
i.e. MbrVal should always be populated by the value at the mentioned intersection. (to prevent a roll up).
when i implement it as ([MbrVal],[No_Entity],[No_Company],[No_Product],[&CurrDay]), it comes back with an error saying .. the recursion limit of [31] has reached. Plz Help
Posted 2008-7-28 17:32
|