Skip to Content
0
Former Member
Jun 30, 2009 at 10:46 AM

Copy Top node of a hierarchy to the leaf node of another - within dimension

56 Views

Hi,

Scenario is, user uploads monthly data in the respective leaf nodes of Monthly Input hierarchy. But at a later stage user might want to adjust figures directly on the Annual level.

For that matter I've got 2 hierarchies in Time Dimension, which look like as below:

Monthly Input

2007.TOTAL

2007.Q4

2007.Dec

2007.Nov

2007.Oct

2007.Sep

.

.

.

2006.TOTAL

Annual Input

xxxx.ANL

2009.ANL

2008.ANL

2007.ANL

I could think of two solutions:

1- To upload monthly data directly into .ANL leaf nodes and add signed data values w.r.t. key dimensions and YEAR. Problem is Append functionality isn't available if you loading/importing data from flat file. Can guide me if, somehow, it is workable or not?

2- To copy the .TOTAL nodes to the respective member of .ANL nodes (e.g. 2007.TOTAL to 2007.ANL). I'm not sure if it is possible or not?

Many thanks in advance for more suggestions and earliest reply.

Regards,

Shabbar

Edited by: Ali Shabbar on Jun 30, 2009 1:00 PM