My requirement is to report on opportunities cube with product hierarchy I have loaded product hierarchy first followed by opportunities but my problem is when i open opportunities cube in BEx analyzer i can see only key that is present in OPP item datasource but i cannot view hierarchy and text evenafter choosing hierarchy; in query output product related objects are displayed as not assigned i even executed hirearchy attribute change run. Would anyone put light on it.
And also I extracted long text thru generic created FM into BW as Characteristic as data target and I passed primary key to cube eventhan i cannot bring the text here also in output not assigned is displayed under text objects. In generic datasource i have taken STXH-TDNAME as primary key but in OPP 0CRM_OHGUID is same as TDNAME(32) i used 0CRM_OHGUID as key in report but text is not displaying. would anyone tell me what is the normal procedure to bring long text(4 parts 60char each) into report after extracting into bw.
would anyone help me in this issues.I appreciate it in advance.
Thanks a lot