Hi all,
We have build a Powerplay cube containing all the data of all period. Each period show information like a monthly picture of the data from our application at that time. Somtimes the end user need to get analyse data only from the last period. To accelerate the processing I think it could be great to create a second cube with only the data of this period (The last one or the current one). So it will create a smaller cube and it will be faster to process and interogate
I was wandering if there is an easy way to do this without adding stuff to identify this information as the last perdiod. I saw that you can use relative date's and let Transformer find out what is the current period. So i've done it in my cube. I was thinking that I would be able to insert a second Cube and use a dimensionnal view that will include only that relative category of my Period dimension. Unfortunatly I did'nt find out how to filter correcly to get only the data of the current period. I want to do this that way because I will not have to change the dimensionnal view each month to specify wich periode have to be include and wich have to be exclude.
Maybe it is not possible to do it like that ... but I would be so nice and easy :p
Is there anyone who had to do this? ... Is there the way to do this?
Thanks in advance :)
Sorry for my bad english ... I usualy speak french
Hi ,
I think u can do this by creating one IQD for Time dimension using the dates from Fact table.Which will always give last period for the fact data.
Now import the New time dimension iqd, and take it as Dimension make the Mark Date as 'Unique' .
When u build the cube, which ever Dates IQD gives, Cube pulls the data from Fact table for those dates..
I hope this helps!
Regards,
Mohan
Hi
You can create special categories in the same cube, which will give you a new dimension only for last period ... !
Cheers ...