Hierarchy Changes (Report)

[Former Member]

Hi Gurus,

We have a report that that gives results according to the hierarchy maintained. Now we have a requirement from the next month onwards, where there has been a slight change in hierarchy. The user wants to look into the results in the report in the new hierarchy from the next month onward. However, they need to have flecibilty that whenever they look data of the current month and months before, they should be able to look into the report according to old hierarchy. How do we achive this?

[Former Member]

The only two options I can think of:

Time dependent hierarchy - driven by the key date.

Version dependent hierarchy

But both the options will work a part of ur requirement but not as whole.

[Former Member]

Could there be any more options?

[Former Member]

Hi SDNBI,

Sounds like it has to be another report based on a different (slightly changed) Hierarchy.

If you are using Bex.....

1) create a workbook and add 2 tabs.

TAB1: old report

TAB2: new report.

When you refresh the workbook, you can use the same set of parameters to refresh both the

workbooks.

Good luck, BB