cancel
Showing results for 
Search instead for 
Did you mean: 

Characteristic Hierarchies and Interactive Charts

Former Member
0 Kudos

Hi,

I have two characteristics hierarchies (sales organizations and material) defined as rows and 3 key figures (sales quantity, amount and value) in column format for a specific queries.

Now I want to design two combo box, respectively for two characteristics hierarchies. say combo box 1 (Sales organizations) for hierarchy one and combo box 2 (Material) for second hierarchy.

I want the combo box 1 should contain the unique values of sales organization hierarchy and combo box 2 should contain the unique values of material hierarchy.

Now depending upon the selection value of sales organization level and material combination, an ineractive chart should be displayed to show the corresponding values.

I think we need to use VB macro to do the above. Please help

Cheers

Rajiv

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Rajiv,

Let me formulate what I think you want.

Your query (SO & material in rows and KFs in columns) result is shown in BEx Analyzer (Excel). Because usually there are too many data for chart presentation, you want to limit it by choosing SO and material. For it you want to place two combo boxes into sheet and let users to select SO and material from the boxes. The result of this selection should be reflected in a linked chart. Is it a proper situation?

Best regards,

Eugene

Former Member
0 Kudos

yes Eugene,

You are perfectly right..

In interactive chart, there are basically 3 dimension - 1 for SO , other for material and third for KFs

and selection of SO and material depend upon the combo box values, as selected by users..

Rajiv

Former Member
0 Kudos

Hi Rajiv,

I think it is not a trivial task. Don’t know wether it is possible at all.

First of all, you need to understand the purpose of this chart: what a user wants to see and compare. Second, you need to determine how the chart should look like. The best way to figured out the latter is to play with a chart in Excel. I did it a little and have seen that 3-D chart you mentioned is not illustrative. Maybe it’s better to fix an SO value and show materials and one of the KFs in a 2-D diagram?

So, you need to construct a chart you need in Excel manually first. When you have a clear picture what you have in rows and columns, it’ll be much easier to figured out if it is feasible in BEx.

Best regards,

Eugene