How should i display hierarchy like column wise for BO Dashbords

[former_member182196]

Dear Friends,

I have a requirement to display hierarchy data in flat format like.

Hierarchy data (Which i have)

India

> East

     > MP

          > Katni

          > Jabalpur

     > CG

          > XYZ

          > ABC

     > Delhi

> West

     > Panjab

     > Rajasthan

> North

> South

I need data like that in analyzer.

Zone	State	City
East	MP	Bhopal
East	MP	Indor
East	MP	Sihora
East	MP	Dewas
East	CG	ABC
East	CG	XYZ
East	CG	ASD
West	Kolkata	ACZ
West	Kolkata	MNC
West	AP	HYD
West	AP	NELL

Thanks in advance for help....

Regards,

SM

[former_member202718]

Hi Satendra,

There could be two options though they are work around,

•      Convert the Hierarchy to Flat File format manually and load the date via flat file and report via analyzer.In one of our projects we have loaded Hierarchy via Flat file and this would be reverse of it.
•     Using APDs by Existing Query->APD->DSO1->DSO2->Cube->Query Analyzer (Need to try this solution)
•     Also Are we capturing them (Zone,State,city) in Individual objects via Transaction data,can we use them in the Query.

rgds

SVU

[former_member182196]

this is master data Hierarchy and can not load via flat file bcz we have standard things.

Can you please elaborate 2 option step by step.... and if you have any document plz preferred me. 

[former_member202718]

Hi Satendra,

Sorry for the late reply.

As said we have to try it out,as i am not on the system i was not able to try it.But i may be possible through APDs.

Rgds

SVU