No Hierarchies for this InfoSource in the Source System

[former_member243717]

Hello All,

I want to find out how to get my hierarchy back in Bex (Query Designer).  We just got a new BW system.  The hierarchy was loading fine in the old system but unable to see it in the new system.  I have done the following and still no luck:

1. Replicated the Datasource
2. Replicated the Source System
3. Maintain Hierarchies shows no hierarchies and when I click on create hierarchy (No values when you click on Hierarchy Name).  Whereas I get hierarchy  values in the old system.
4. In the Infopackage, click on Hierarchy Selection => Available Hierarchies from OLTP, I get "There are no Hierarchies for this InfoSource in the Source System".

Is there anything am missing?  My suspicion is may be the Hierarchies need to be maintained in ECC first and then I should replicate again and then load the hierarchy.

Any suggestion would be appreciated.

Thanks,

Recca

[former_member227168]

Hi Recca,

In OLTP(ECC) system will support Hierarchy ?,

I think not support for loading Hierachy in OLTP system.

Please check it once,

InfoSources are availble in BW system to communicate with source and target.

Thanks,

Ram

[former_member243717]

Thanks guys,

@ RDS:  I can only find the hierarchy for Commitment Item - FMCIE.  The Fund and Fund Center did not work.  But I was able to pull FMCIE and compared the old system with the new system and they are both same.......meaning everything has been migrated over from our old system to the new system.  The correct t-codes are below:

FMCIE - Commitment Hierarchy

FMSA- Create Funds Center in FM Area

FMG3 - Display Budget Structure Template

@ Sai:  When you click on "Hierarchy Selection" in the InfoPackage and then "Available Hierarchies from OLTP", this is to refresh the hierarchy list from OLTP.  We were able to do this in the old system and can still do it now, but not in the new system.  When I do that in the new system, I get  "There are no Hierarchies for this InfoSource in the Source System".

I cannot pin point the piece that is missing.  Any help would be appreciated.

Thanks,

Recca

[sai_adapa]

Hi Recca,

Are you able to see these hierarchy data sources in the new system?.

Unless you load the hierarchies data, you are not able to see these hierarchies in the maintenance.

Try to load the data to the hierarchies.

Regards,

Sai

[rajdeep_singh]

Hi Recca,

Please check if connection between R/3 and BW system is  maintained properly.

While loading Hierarchy Info packages there is an option to select the hierarchy which you want to load under info package tab. Please verify if that has been done.

You can also check if your hierarchies are available in ECC system with help from your functional team or any changes have been done which have caused those hierarchies to go missing .

Please do revert in case you need any further details.

Thanks & Regards

RDS

[former_member243717]

Thanks Sai and RDS.

@ Sai:  Yes, the Datasource is present in BW as 3.x version which I assume is ok.  It is also present in active version in ECC in RSA6.  There is nothing to load for the hierarchy because when you click on the InfoPackage the "Hierarchy Selection" and then "Available Hierarchies from OLTP", in other to refresh the list, I get "There are no Hierarchies for this InfoSource in the Source System".

@ RDS:  Yes, the connection of BW to the ECC Source System is good....checked out ok.  There is nothing to load for the hierarchy because when you click on "Hierarchy Selection" and then "Available Hierarchies from OLTP", in other to refresh the list, I get "There are no Hierarchies for this InfoSource in the Source System".

Besides RSA6 to check the datasource in active version in ECC, do you have a T-Code to check where these following Hierarchies are maintained in ECC?  I need to compare it from the old system with the new system.

1.  Fund

2.  Fund Center

3.  Commitment Item

Thanks,

Recca

[rajdeep_singh]

Hi Recca,

Please find below t-Codes:-

FMSA- fund hierarchy

FM51- fund center hierarchy

FMG3 - commitment hierarchy or FMCIE -Commitment item Hierarchy

Do revert in case you need any further details.

Thanks & Regards,

RDS