Skip to Content
0

How to change Dimension filed dynamically in Hierarchy chart?

Oct 24, 2017 at 03:13 PM

61

avatar image

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

c1.png (22.7 kB)
10 |10000 characters needed characters left characters exceeded

Hi Chandrasekhar,

Can you post a screenshot of:

1) The data source Initial View

2) The chart configuration panel.

Thanks,

Mustafa.

0

Hi Mustafa,

Please find screen shots,

1.

2.

Thanks,

Chandrasekhar

chart.png (16.9 kB)
0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Oct 24, 2017 at 04:13 PM
0

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy,

Thanks for your quick response.

We are using Lumira 2.0 SP02.

Thanks,

Chandrasekhar

0

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

0
Mustafa Bensan Oct 27, 2017 at 11:58 AM
0

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.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Mustafa,

Thanks for reply,

I tried your process but I am getting hierarchy

In edit initial view,

and output chart ,

Thanks,

Chandrasekhar .K

chq.png (18.6 kB)
0

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

0

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

0