How to use dynamic member for ASO member formula
Dear every expert,
I have a member under the dimension "Plan Element" which has the member formula on the ASO cube:
NONEMPTYTUPLE([M_NET_SALES])
([Account].CurrentMember) / ([Account].[M_NET_SALES])
However, M_NET_SALES is dynamic member.
So when I tried to refresh the database, it showed error :
Unknown member.
When I changed M_NET_Sales to a store member —> I could refresh database normally.
Is there any way for me to work with a dynamic member in the ASO cube ?
Thanks and have a nice day!
Tagged:
0