Layout with months on rows and years on columns

Unknown

hello,

 

I would like to make a layout with months on rows and years on columns. If a insert in axes years on columns and months on rows I have that every months is in a different rows.

 

Desired is.

Instead of:

Best regards,

Gabriele

Alexander Kappes

Dear Gabriele Benecchi,

 

thanks for your request.

 

You can solve e.g. with using custom time Entity.

 

This can for example have the Name "Month without Year". You can insert as Aggregation of Month.

 

Now when you manage your time Relations for that you can use the new Custom Dimension in your DataView and got the wished behavior.

 

Hope it helps.

 

regards

 

Alexander Kappes

Unknown

Dear Alexander,

 

thank you for your answer. I tried to implement it but it is not working. 

Here below you can find some screenshots of what I configured. "Mese senza anno" is "Month without year".

The last screen where we add the cube version was only latest attempt. We thought it has to work also without setting it.

 

Regards,

Gabriele Benecchi

 

Alexander Kappes

Dear Gabriele Benecchi,

 

I think you only have forgotten to map the Month without Year to the Detail Levels of Month.

 

You must create the indirect Relations to Week and Day that it will work.Easiest way doing this will be using ASCII DateReader and ETL which manages / creates the Relations.

 

The Cube Version you didn´t realy Need to get it work.

 

Hope it helps

 

regards

 

Alexander Kappes

Dietmar Jeschkeit

Dear Gabriele,

 

I think your versioning of the cube isn´t correct. The first Version must be the most detailed. In your Picture it seems that the second Version is more detailed then the first one.

Previous Member

I ussually use a separate entity for month without year add the entity to my cubes. 

In the ETL process I create a rule to convert the date to the month without year.

Or alternative you create a cube where you link the months with year to the months without year and run a process to transfer you date to a cube which contains the entity month without year.

 

best regards,

 

RJ