on 12-07-2013 11:40 PM
Hi gurus,
I have a dimension holding date format data and when I use it with Month(Date) like formula one column values turned to #unavailable.Isn't that very interesting that the change for one particular column effects other.
The source is BEx and sales order cube is on use. I would really appreciate your returns.
Eddy.
That is the normal behavior with DB-delegated key figures as the tools sees a different aggegation (here: monthly) that it cannot calculate (because kf database delegated).
Use conditional formating (a.k.a. alerters) in order to display the variable.
best regards,
Victor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Keep the Dimension (Date) in the table and hide it if you don't want to display it.
Now, it shouldn't give #Unavailable error.
Kindly update after you try.
Thanks,
Parthiban
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.