Hierarchy not seen after replication of custom hierarchy datasource ?

[former_member182467]

Hi,

I need to build a custom datasource to extract ecc hierarchy to BW.

I have generated the datasource in ECC manually through BW07 and enhanced the code in CMOD for the controlling area compuonded IOBJ and replicated to BW. But unable to see the set name/hierarchy name in BW ( hierarchy tab) of the infopackage. How do we resolve this issue ? Please advise.

Thanks

DR

[Former Member]

Hi Daniel,

I think you are doing  your things in one client and loading to BW from other client. Use SCC1 and  transfer the  changes from one client to  other and then start loading into  it.

Regards,

Rajesh

[former_member182467]

Hi Rajesh,

I have checked that its the same client. The problem is even in RSA3 in the same client in ECC I don't see that hierarchy in the selection.

Thanks

DR

[Former Member]

Hi  DR,

1)s that BW to source  system  connection is fine?.

2) Please  go  to connection parameter in source  system and check whether the system name of the source system is same as yours.  It could have  been possible that basis team  did  a connection name as like your SS name  but which is  actually  a different SS.

Regards,

Rajesh

[former_member182467]

Hi Rajesh,

Forget about the connection to BW. As the hierarchy is not even seen in ECC, RSA3 in the Hierarchy selection window. Any suggestions.

Thanks

DR

[Former Member]

Hi DR.

Its strange. You mentioned in earlier posts that you can see in RSA6 and not in RSA3.  To my  understanding  , it should come in RSA3 if it is available  in RSA6.

  I can only think of  raising to SAP  a OSS message  to SAP as  we checked all the possible suggestions from experts.

Regards,

Rajesh

[former_member182467]

Rajesh,

I can see the datasrouce in RSA6 and I can see the datasource in RSA3 as well. While running the DS in RSA3, and execute it. I am unable to select the hierarchy which exist in GS03. We have so many sub-group's in GS03 for which we need to select the sub-group name while extracting that respective hierarchy right ?

I am unable to see the sub-group name/set name which exist in GS03, in the hierarchy selection in RSA3. Its not about the datasource. Its about the hierarchy selection either in RSA3 or infopackage selection ( for that respective hierarchy) . DS is replicated fine to BI.

Hope the picture is clear now ?

Thanks

DR

[Former Member]

Hi DR,

Can you try the below please?.

1) go back to GS03. Enter the SET name and press enter which will take to the sub-ordinate sets. Double click on each SET line to display the details.

Field: FGr which will be utilized for the Sign reverse activation for a particular line or node or account. If any of the SET line has a value ‘4’ then that line will be marked as ‘X’ in the actual hierarchy

Regards,

Rajesh

[Former Member]

Hope this information will be useful.

http://scn.sap.com/docs/DOC-30698

Regards,

Suchitra

[former_member182467]

Hi Suchitra,

I have exactly done the same steps. But not yet mapped to the BW MD as after creating the infopackage I am unable to see the required hierarchy in the hierarchy selection tab. I have also checked "check the available hierarchy in ecc" to check and replciated the ds. By the way I dont see it in the RSA3 in ECC end as well....while pressing the F4 in the hierarchy selection in RSA3. Any advise.

Thanks

DR

[Former Member]

Do you see this hierarchy data source in RSA6?

Regards,

Suchitra

[former_member182467]

Yes it appears under FI-SL category. Its active as well. Any other advise

[Former Member]

Check this thread which speaks about maintaining entries in ROOHIECAT table for the hierarchy data source. I have never tried before. See if this will help you.

Regards,

Suchitra

[RamanKorrapati]

Hi,

Again replicate your data source and activate.

Create a new info package and see.

Thanks

[former_member182467]

Hi Ram,

I have replicated it multiple times, well I dont see the hierarchy in the RSA3 itself. Am I missing anything or any other steps required on ECC end while generating the DS.

Thanks

DR