If you are unable to create a new account, please email support@bspsoftware.com

 

need to apply Previous day filter/Slicer in the Analysis Studio Report.

Started by devardekartb, 19 Feb 2016 08:41:29 AM

Previous topic - Next topic

devardekartb

I have 3 cubes and requirment from user to automate them for the previous day.I have opened the cubes in analysis studio and saved them in report studio.
I have then applied the slicer "tail([Cube_GEMS_FISC_Comm_Rec].[Trade Enter Date].[Trade Enter Date].[Day])" in all three reports but only two of them are working correctly. The third one cube has future dates already loaded in it hence the "Tail" function is not working as expected. How do I set the " [Cube_GEMS_ADP_Comm_Rec].[Trade Date].[Trade Date]" equal to previous day.(current_day-1)?

Please advise.

MFGF

Quote from: devardekartb on 19 Feb 2016 08:41:29 AM
I have 3 cubes and requirment from user to automate them for the previous day.I have opened the cubes in analysis studio and saved them in report studio.
I have then applied the slicer "tail([Cube_GEMS_FISC_Comm_Rec].[Trade Enter Date].[Trade Enter Date].[Day])" in all three reports but only two of them are working correctly. The third one cube has future dates already loaded in it hence the "Tail" function is not working as expected. How do I set the " [Cube_GEMS_ADP_Comm_Rec].[Trade Date].[Trade Date]" equal to previous day.(current_day-1)?

Please advise.

Hi,

Firstly, a comment. Moving content authored in Analysis Studio into Report Studio is not necessarily a good idea. If you look at the items and expressions Analysis Studio generates, it can be quite horrifying! In an ideal world I would author these three reports from the outset in Report Studio.

Notwithstanding, I can see why the approach you are using here wouldn't work where the cube is populated with date members going off into the future. As I see it, you have two options:

1. Use a macro in your report to build the MUN of the member corresponding to today's date. There are a number of examples of how to do this already in these pages, but each one is subtly different - usually because the MUNs of the cubes were different each time. To advise you how to do this in your case, we would need to see the MUN of a member from your day level.

2. Build the 'Previous Day' member into your cube, so that all an author has to do is to select it in their report or analysis. You don't mention what cube technology you are using here, but many of the OLAP modelling tools for cubes provide the capability to define relative time.

Cheers!

MF.
Meep!