cancel
Showing results for 
Search instead for 
Did you mean: 

I identify Nodes in Hierarchy in CR Enterprise

DebjitSingha
Active Contributor
431

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
0 Kudos

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
Active Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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

Thanks,

Debjit

Former Member
0 Kudos

Hi Debjit,

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

Thank you

James

Former Member
0 Kudos

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
0 Kudos

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
    Active Contributor
    0 Kudos

    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
    Active Contributor
    0 Kudos

    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
    Active Contributor
    0 Kudos

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

    DebjitSingha
    Active Contributor
    0 Kudos

    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
    Active Contributor
    0 Kudos

    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
    Active Contributor
    0 Kudos

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

    DebjitSingha
    Active Contributor
    0 Kudos

    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
    Active Contributor
    0 Kudos

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

    Tammy

    TammyPowlas
    Active Contributor
    0 Kudos

    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
    Active Contributor
    0 Kudos

    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
    Active Contributor
    0 Kudos

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

    DebjitSingha
    Active Contributor
    0 Kudos

    Tammy,

    Please do that.

    Thanks,

    Debjit

    TammyPowlas
    Active Contributor
    0 Kudos

    Done

    abhilash_kumar
    Active Contributor
    0 Kudos

    Moved!

    DebjitSingha
    Active Contributor
    0 Kudos

    Thanks Abhilash.

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

    Thanks,

    Debjit

    DebjitSingha
    Active Contributor
    0 Kudos

    Hi Abhilash,

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

    Can you please help.

    Thanks,

    Debjit

    abhilash_kumar
    Active Contributor
    0 Kudos

    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
    Active Contributor
    0 Kudos

    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
    Active Contributor
    0 Kudos

    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
    Active Contributor
    0 Kudos

    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