I am doing a Bursting on daily sales report . So my days dimension has 1 -31 days and Region dimension , product dimension and with a sales Measure.
so the report is always filtered on previous day sales. Say I run on 12 th , it will filter for 11 . The cube builds daily night.
So we will not know if the cube has previous day data, there could be some failure that caused to load previous data.
In that case now my slicer on days will fail since it is not able to find that member.And report will not be bursted.
But now I have a requirement that the report should show an error message saying the report did not build last night if the previous day sale was <=0.
How can I achieve this, can I check on a member which is not on a cube like
if( tuple([sales],[PreviousDayMun]>0) then 1 else 0)
And show Page 1 which is errror text and page 2 which is a burst report.
Any suggestions is appreciated.
Thanks,
Nithya
Isn't there a No Data option in the list/crosstab properties? You could just alter that message to say that the cube didn't build.
One thing I'm not sure about is what happens if the cube doesn't build on the 12th (in your example)...will the previous day dimenion show as the 10th? You might need to do some testing...
If there is no member then bursting will not happen, it will have error in the report , saying mun could not be found.
if I use last member in the days dimension, then I will be showing 10 the date report if 11 fails .Does dont seem to work so thats the reason iused slicer with previous day. Also , I tried this
Boolean report expression tuple([Sales],#'[DailySales].[Day].[Day].[Day1]->:[PC].[@MEMBER].[' +timestampMask( _add_days ($current_timestamp, -1 ) , 'dd' ) + ']' #)>0 And I get an error failed to validate the boolean.
Thanks,
Nithya
Cant I use tuple(Mun,Measure) in conditional variables like boolean or string ?
Quote from: nithya1224 on 20 Jan 2016 10:21:00 AM
Cant I use tuple(Mun,Measure) in conditional variables like boolean or string ?
Even if you could resolve the issue with the Boolean you'd still be trying to reference something that potentially doesn't exist which would probably land you right back in the same situation as you have with the slicer.
I think you'd be better off trying to determine the last member in the dimension and then comparing the caption of that member with what the caption ought to be for the current day.
Cant I check the condition in the conditional variable ?
if (Caption( tail ( [DailySales].[Day].[Day] , 1 ) ) ='19')
then(1)
Else(2)
Then for 1 I would show the cross tab and for 2 I will just show the error message.
How do I check this condition in my conditional variable?
This throws an error saying the function name was not found.
Thanks,
Nithya
Can anyone suggest me on how to check the if condition on a conditional variable
if (Caption( tail ( [DailySales].[Day].[Day] , 1 ) ) ='19')
then(1)
Else(2)
The above doesn't work .
Thanks,
Nithya