Make one cube in a layout time independent

Previous Member

Hi there!

I have a simple layout, with two cubes shown in a dataview.

One of those cubes should react on the time selection I make, but the other one, should show me all years

or to be more precisely, the cube should not react on the time selection.

Is that possible?

Regards

Toni

Find more posts tagged with

Accepted answers

All comments

Previous Member

Hi Antoni Theodorou,

there are several approaches to have a cube reacting on the time selection and at the same time to show all years.

I think the easiest way would be to duplicate the cube but without the time dimension. This way you get the cumulated values of all years which won't be affected if you use any time selection.

Hope this gives you some inspiration

Best regards

Bettina

Previous Member

Hey Bettina Clausen,

thanks for that ! I´ll try it

Andrea Masiero

Otherwise you create an aggregation of the entity year with one member "ALL" related to all years.

Then you apply a refer-to to this entity in the bloc that shouldn't be impacted by time selection.

The result is the same, in one case (Bettina idea) you add a cube, in my case you add an aggregation of years.

It's matter of implementation style now.

Hope it helps

Andrea

Samuele Marchetto

There is a third solution. In the block "time independent" set:

- a refert to to the last period of the cube (for example last month defined in the database)

- a Yearly Moving Total with cycle 1000 or more.

Problems:

- depending on the cube, this approach could be very slow

- you have to use a statical "refer to" to the last month (for infocubes by month) or the last day (for infocubes by day)