I identify Nodes in Hierarchy in CR Enterprise

[DebjitSingha]

Hi,

Is there a way to identify hierarchy nodes in CR Enterprise so that we can use it in calculation. I am using Crystal Reports Enterprise  4.0 and connecting to BEx query.

Thanks,

Debjit

[Former Member]

Hi Debjit,

Isn’t this essentially the same issue you faced in this discussion?

http://scn.sap.com/message/14337210

I don't have cr4e installed, but I would hope the [NodeID] attribute for the hierarchy field is available to include in the query panel.  Is it not there??

[DebjitSingha]

Thanks Mike,

We have the report ready in CR2011 (thanks for that), only issue is that we cannot publish the same in BO server. As the underneath OS (Red Hat 6.2) is not supported for CR ReportApplicationServer. As after publishing the report we will be able to view LOV in CR.

The node Id field is not available in cr4e. Beside the hierarchy structure is either completely displayed in BODY section of on GE section. So there is not way I can differentiate levels.

Thanks,

Debjit

[Former Member]

Hello Debjit,

you can use the HierarchyLevel function in a formula for this.

See the Crystal Reports for Enterprise help:

HierarchyLevel (GroupingLevel)

Description: Returns a number that indicates the hierarchy level of the current group member when you have sorted your group hierarchically.

Arguments: GroupingLevel is a function that determines the level of an existing group. For more information, see GroupingLevel (fld).

Returns: Number

Action: Returns a number that indicates the hierarchy level of the current group member when you have sorted your group hierarchically.

Typical uses: If you want to use a conditional-x-position formula to determine the indentation of individual members in a hierarchical group sort, use this function to track the levels.

Examples

HierarchyLevel (GroupingLevel ({Employee.EmployeeID}))

Returns the level number of each member in your hierarchy assuming that your report is grouped hierarchically on the EmployeeID field.

Comments

This function is evaluated in Pass 2

Thank you

James Anderson

SAP Active Global Support

[DebjitSingha]

Thanks James. but now we end up with other issues with Grouping  (unexpected shorting when we use multiple groups)

Thanks,

Debjit

[Former Member]

Hi Debjit,

can you provide more details or send me an example report?

Thank you

James

[Former Member]

Hi Debjit,

if you have an example report please upload it to the following link.

https://share.sap.com/a:rcw0xw/MyAttachments/R.e3d99b85-aba7-47af-9cec-ff19347134b8/

Thanks

James

[Former Member]

Hello Debjit,

you can use the HierarchyLevel function in a formula for this.

From the Crystal Reports for Enterprise Help:

HierarchyLevel (GroupingLevel)

 

Description

Returns a number that indicates the hierarchy level of the current group member when you have sorted your group hierarchically.

Arguments

GroupingLevel is a function that determines the level of an existing group. For more information, see

Returns

Number

Action

Returns a number that indicates the hierarchy level of the current group member when you have sorted your group hierarchically.

Typical uses

If you want to use a conditional-x-position formula to determine the indentation of individual members in a hierarchical group sort, use this function to track the levels.

Examples

Returns the level number of each member in your hierarchy assuming that your report is grouped hierarchically on the EmployeeID field.

Comments

This function is evaluated in Pass 2.

Thanks

James Anderson

SAP Active Global Support

[TammyPowlas]

Yes

Assuming you defined a hierarchy in your BEx query this should work.

See below - enable levels

You would want to group and subtotal to Level 2

[DebjitSingha]

Tammy,

Thanks. We want to use the level reference in different formulas. Is there a possible way to use levels in formulas in CRE.

One of the example  : highlighting certain node levels in report

Thanks,

Debjit Singha

[TammyPowlas]

Can you give me an example of such a formula and I will try in my query?

[DebjitSingha]

This is one of my query.

http://scn.sap.com/message/14354750#14354750

Please let me know if you need any other info.

Thanks,

Debjit Singha

[TammyPowlas]

Sorry, but I am not getting your question about the formula part?

This is normal group/subtotaling within Crystal for Enteprise, as shown in the screen shots above.

[TammyPowlas]

Not sure this applies to your version - please see > discusses similar concepts.

[DebjitSingha]

Hi Tammy,

with this approach all nodes are appearing in either body section or on GH1 section , but with proper indentation.

• Lets say we want level only 2 nodes to appear bold (font)

           AAA                     

                    BBBBB                 1 

                    BBBBB                 1

• Say we don't want to display keyfigures for first node / Parent node.

• Lest say we want keyfigures to be aligned properly  (not with indent). Instead of below:

           AAA                      

                    BBBBB                 1 

                              CCCC                    1

                                       DDDD                    1

Thanks,

Debjit Singha

[TammyPowlas]

Now I understand...it's late here, I will take a look at it tomorrow.

Tammy

[TammyPowlas]

I am not able to get this to work with BEx and Crystal for Enterprise.

Could you please move this discussion to the as it might get more expert help with Crystal and BEx in that space.

To move select the actions on the right, move and then select

[DebjitSingha]

Hi Tammy,

For some reason I am not able to locate "Move" under Action. Is it possible for you to move this discussion?

Thanks,

Debjit Singha

[TammyPowlas]

I am not the moderator of this space; perhaps can, or I can "Report Abuse" and ask the moderator to do this.

[DebjitSingha]

Tammy,

Please do that.

Thanks,

Debjit

[TammyPowlas]

Done

[abhilash_kumar]

Moved!

[DebjitSingha]

Thanks Abhilash.

Lest see if CR4E is allowed to do, what we are looking for.

Thanks,

Debjit

[DebjitSingha]

Hi Abhilash,

Seems like the discussion is again moved back to Crystal Reports Group.

Can you please help.

Thanks,

Debjit

[abhilash_kumar]

Maybe they feel it's more related to CR for Enterprise than BI as a whole, which I think is right.

Unfortunately, I don't have an SAP BW environment to test and come up with something.

I hope someone else who has access to BEx queries and CR for Enterprise could come up with something.

-Abhilash

[DebjitSingha]

Hi Abhilash,

We have the report ready in CR2011, only issue is that we cannot publish the same in BO server. As the underneath OS (Red Hat 6.2) is not supported for CR ReportApplicationServer. As after publishing the report we will be able to view LOV in CR.

Then we decided to move to CRE (unfortunately not able to get the requirement done with CRE).

is there any other alternative that we can use CR2011 and still have the leverage of LOV in report.

[abhilash_kumar]

The LOV, unfortunately, can only be used with the (legacy) CR Designer.

Well, if the report works fine in CR 2011, it's strange it doesn't work in CR for Enterprise.

-Abhilash

[DebjitSingha]

Abhilash,

Can we save the report back to BW repository? Whether we will be able use dynamic LOV's.? Provided that we use Crystal Viewer.

We were not able to replicate the same report with CRE because there is no way that we can identify the hierarchy level in the report. In CR 2011 we used field "node ID" to distinguish each levels.

Not sure whether it is possible with cr4e.

Thanks,

Debjit