Skip to Content
0
Former Member
Jun 04, 2009 at 01:50 PM

Hierarchy settings in Bex Query Designer

161 Views

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--


Product-- -Sale Qty -- -Sale Revenue --

-


> North--


1A
XXXX

XXXX
--


-


2A--


XXXX
XXXX
--


-


3A--


XXXX
XXXX
--


-


4A--


XXXX
XXXX
--


-


5A--


XXXX
XXXX
--


> South--


1A
XXXX

XXXX
--


-


2A--


XXXX
XXXX
--


-


3A--


XXXX
XXXX
--


-


4A--


XXXX
XXXX
--


-


5A--


XXXX
XXXX
--


WHEN I EXPAND Hierarchy (Lets conside for Noth)

V-North--


1A
XXXX

XXXX
--


-


2A--


XXXX
XXXX
--


-


3A--


XXXX
XXXX
--


-


4A--


XXXX
XXXX
--


-


5A--


XXXX
XXXX
--


Store_ID1--


1A
XXXX

XXXX
--


-


2A--


XXXX
XXXX
--


-


3A--


XXXX
XXXX
--


Store_ID2--


4A
XXXX

XXXX
--


Store_ID2--


5A
XXXX

XXXX
--


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--


1A
XXXX

XXXX
--


-


2A--


XXXX
XXXX
--


-


3A--


XXXX
XXXX
--


Store_ID2--


4A
XXXX

XXXX
--


Store_ID2--


5A
XXXX

XXXX
--


Thanks