Problem of selection on Time range

Hello dear community,
I have a problem that you may have already encountered. Indeed, I seek to make a double selection on the time axis in a procedure to perform a calculation. To be done I created in the time range "Month reporting", which contains only the months of January to December (if we select month reporting = January this selects the months of January 2012, January 2013, January 2014 etc) . I also have a cube "year of work N-1" that allows me to determine the year on which I want to perform my calculation. So I would like in my procedure selects the December this year N-1. To do so I apply a first selection on the year via the cube "year of work N-1" and I then apply a second selection on the time axis "Month reporting" that I created. However, when I execute the procedure, the selection runs only on the year and not on my "month reporting" entity. The problem also exists when I make the selection in a screen. Have you ever encountered this problem? or do you know alternative methods? I put in place a substitution method but it requires the creation of several cubes.

Find more posts tagged with

Accepted answers

All comments

Previous Member

Hi Pierre Rosnarho,

do you want to apply two restrictions on the month entity?

Do I assume correctly, that want to select one month from one year?

BR, Ray

unknown

Hi Ray Martens

Yes that's right. I want to select a month from a year (year determined by a selection on a cube).

Previous Member

I'm not yet sure how you select your month. Is it this way (1):

you have an entity called "month reporting"
this entity contains the values "January", "February", "March", "April", "Mai", "June", "July", "August", "September", "October", "November", "December"
setting the selection on "month reporting" via a pager triggers a procedure that changes the selection on the month entity. e.g. selecting "January" will set the selection on the month entity to "January 2012", "January 2013", "January 2014", "January 2015", "January 2016", "January 2017", "January 2018" and "January 2019" - in this example 8 months from 8 different years are selected.

or is it this way (2):

you have a custom time entity called "month reporting"
this entity contains the values "January", "February", "March", "April", "Mai", "June", "July", "August", "September", "October", "November", "December"
"month reporting" is connected to the month entity like this:

entity "month"	entity "month reporting"
January 2012	January
February 2012	February
…	…
December 2012	December
January 2013	January
…	…
December 2013	December
…	…
Mai 2019	Mai

setting the selection on "month reporting" via a select or pager directly restricts the selection on the month entity as they are hierarchically connected.

In both cases you should first select the month, then apply "select entity based on cube" using "keep mode" in order to refine your selection to one year:

BR, Ray

Graeme Whorrall

Hi Pierre,

Think I have a nice solution for you.

first lets get to the route of the issue the issue is because you select a month what this does is go down to lowest entity (day) and then only select relevant ones.

when you select Year it does the same so overrides your original what you need to do is do a select for the month write that (clear Cube A) then make cube A (based on month/ day only) =1 so that only the month of January over all time =1.

then you select year and do a data reader from cube a to cube a and set were it is 1 e.g. the only the month you want and the year you want to set where it =1 to =2 so in affect now all you want to do is filter to 2.

then you can clear your selection on time and then use Cube A to populate Cube B (clear cube B first) and set cube b =1 where cube a =2 so only where the 2 selection work will it set b to what 1 then filter time on cube B.

hope that makes sense.

regards

Graeme