Hi,
Please update how to achieve this
I had a sales report on Store & Product ,Sale Qty (KF) & Sale Revenue(kf)
I had a Hierarchy created on Store (North,West,South,East & Central)(Node1).....Store ID (1A,2A...etc) (Node 2)
In my cube store id are loaded.
In my Query i restricted Hierarchy to North & South
User executed report by entring Month intreval.
INITIAL VIEW
Store--
-
> North--
-
2A--
-
3A--
-
4A--
-
5A--
> South--
-
2A--
-
3A--
-
4A--
-
5A--
WHEN I EXPAND Hierarchy (Lets conside for Noth)
V-North--
-
2A--
-
3A--
-
4A--
-
5A--
Store_ID1--
-
2A--
-
3A--
Store_ID2--
Store_ID2--
Actually it is displaying the Same Product ID twice when expanded
My requirment meets with the initial view...
How can i achive the below view when expanded
V-North
Store_ID1--
-
2A--
-
3A--
Store_ID2--
Store_ID2--
Thanks