Transformer : Cube with only last period

[loysqc]

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

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

 

[drlex]

loysqc,
I had a similar requirement. I found it easier to run a copy of the transformer model again using transactional iqds set to return the current period only and then set the drill through from the "full" cube to the single month, "current" cube.
(If you do not require a drill-through, then the same model can be used to build both cubes.)
lex

soi là, soi carré