Help with hierarchy variables

[Former Member]

I am unable to get a hierarchy variable to show up in my Crystal Report. I am following the directions in the Users Guide but not getting the expected results. I am selecting a hierarchy variable (user entry) when selecting a hierarchy for the characteristic. When I create a new report against this query I do not see the hierarchy variable. The hierarchy node variable also does not appear, but this is normal because it is an authorization variable, not a user entry variable.

I am running CR XI R2.

Edited by: Mike Garrett on Feb 12, 2009 5:13 PM

Edited by: Mike Garrett on Feb 12, 2009 5:14 PM

[IngoH · Accepted solution]

Hi,

take a look at note 1007048

Ingo

[Former Member · Accepted solution]

Ingo,

Thanks for the response. However, when I search for note 1007048 I don't find anything. Are you sure this is the right note?

[IngoH · Accepted solution]

Note 1007048 - MDX: Filtering of variables in the hierarchy display

Symptom

In the Business Explorer (BEx) variable dialog, a variable for the hierarchy names is displayed. This variable is used solely in the settings for displaying the hierarchy in the query. The system fails to display this variable in the output of BAPI_MDPROVIDER_GET_VARIABLES

Solution

After you implement this correction, you can enter the value "X" for object "MDX_ALL_HIER_VAR" in program "SAP_RSADMIN_MAINTAIN". This ensures that all of the variables for the hierarchy names are always displayed in BAPI_MDPROVIDER_GET_VARIABLES

[Former Member · Accepted solution]

Ingo,

I'm sorry. It's not clear to me what the solution is from the contents of the note. When it says "After you implement this correction", what correction is it talking about? I tried running the transaction "SAP_RSADMIN_MAINTAIN" but it was not found in our environment.

[IngoH · Accepted solution]

Hi Mike,

the note also has a correction attached to it which needs to be implemented first.

Its not a transaction. it s program that you need to run in the system (SE38).

Ingo

[Former Member · Accepted solution]

Unfortunately I am still unable to find this particular note in the SAP Support Notes. Is it possible to get a copy of the correction that is attached to this note?

[IngoH · Accepted solution]

Hi Mike,

not sure why you having that issue. you go to http://service.sap.com/notes and enter the note number.

the note needs to be imported into the SAP system directly

Ingo

[Former Member · Accepted solution]

Thanks for your help. I created a new query with a hierarchy variable and it is now creating a Crystal side parameter.