cancel
Showing results for 
Search instead for 
Did you mean: 

#unavailable ???

erdem_sephanelioglu
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

erdem_sephanelioglu
Participant
0 Kudos

Hi,

Unfortunately not working.

I also tried with vertical table as well as cross tab

Former Member
0 Kudos

Eddy,

Kindly disable the Query Stripping under Document properties and Refresh the Report once.

Kindly update the discussion after trying this.

Thanks.