How to change Dimension filed dynamically in Hierarchy chart?

[chandrasekhar6]

Hi Team

I have create a Calculation view with time based hierarchy like Year-->Quarter-->Month.

Create a Analytics Application using Calculation view it shows output as below,

In above select year field but Dimension shows Month

how to change dynamically field name.

Thanks,

Chandrasekhar

[MustafaBensan]

Hi Chandrasekhar,

Can you post a screenshot of:

1) The data source Initial View

2) The chart configuration panel.

Thanks,

Mustafa.

[chandrasekhar6]

Hi Mustafa,

Please find screen shots,

1.

2.

Thanks,

Chandrasekhar

[MustafaBensan]

Hi Chandra,

Based on the data source Initial View, the chart behaviour you are experiencing is completely as expected. Since your time hierarchy is constructed on year > quarter > month, you should activate the hierarchy on the year dimension instead of the month dimension and place the year dimension in the rows instead of the month dimension.

Regards,

Mustafa.

[chandrasekhar6]

Hi Mustafa,

Thanks for reply,

I tried your process but I am getting hierarchy

In edit initial view,

and output chart ,

Thanks,

Chandrasekhar .K

[MustafaBensan]

If you don't want the hierarchy then you should deactivate it in the initial view.

[chandrasekhar6]

When I was deactivate hierarchy in initial view hierarchy not working in chart.

[TammyPowlas]

Hello Chandra,

Which version/SP are you using?

Have you seen this blog - https://blogs.sap.com/2015/08/14/dynamic-day-selection-for-a-component/ - I wonder if the script would work against the calculation view.

[chandrasekhar6]

Hi Tammy,

Thanks for your quick response.

We are using Lumira 2.0 SP02.

Thanks,

Chandrasekhar

[TammyPowlas]

Chandra - then I will look at the script option in the blog. I am not sure if it will work with HANA calc views.