How to use dynamic member for ASO member formula — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!