Skip to Content
author's profile photo Former Member
Former Member

Expanding and collapsing to show totals and subtotals

Hello,

I have a transactional cube where I want to show data in Web Interface .A cross-section of the data :

Company Account Year Period Cost

-


SAP ACC001 2005 1 100

SAP ACC001 2005 2 100

SAP ACC001 2005 3 100

SAP ACC001 2005 4 100

SAP ACC002 2005 1 100

SAP ACC002 2005 2 100

SAP ACC003 2005 3 100

SAP ACC004 2005 4 100

So the requirement is that the user should be able to see total for an account (say ACC001) .So my idea is that if I can allo the user to expand and collapse on the account so that he sees the data something like this ..

Company Account Year Period Cost

-


SAP ACC001 2005 # 400

Any help would be greatly appreciated.

Thanks in Advance,

Priyadarshi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2005 at 06:36 AM

    Hi,

    in a BEx query you must place the characteristics Company, Account, Year Period in rows and KF Cost in columns. Then you switch the rows to "Display as hierarchy" and "Expand To ..." to Account.

    Hope this helps.

    Rgds.

    Jürgen

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2005 at 07:41 AM

    Hello,

    I am sorry as I was not very clear with my question.

    I have a transaction cube .Then using BPS0 I create a planning layout and planning fuunctions.Then I am displaying the data in Web Interface which I have created using the Web Interface Builder.A cross-section of the data :

    Company Account Year Period Cost

    -


    SAP ACC001 2005 1 100

    SAP ACC001 2005 2 100

    SAP ACC001 2005 3 100

    SAP ACC001 2005 4 100

    SAP ACC002 2005 1 100

    SAP ACC002 2005 2 100

    SAP ACC003 2005 3 100

    SAP ACC004 2005 4 100

    So the requirement is that the user should be able to see total for an account (say ACC001) .So my idea is that if I can allo the user to expand and collapse on the account so that he sees the data something like this ..

    Company Account Year Period Cost

    -


    SAP ACC001 2005 # 400

    Any help would be greatly appreciated.

    Thanks in Advance,

    Priyadarshi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Raj,

      Hierarchically structured planning using BPS0.

      (1) Create a manual planning layout.

      (2) In the first step while creating a layout you need to make a setting where you can specify "Hierchical Data Model" and also specify "Top Down" or "Bottom Up".

      The setting can be done in the Hierarchy in Lead Column dialog box by clicking on Hierarchy button(this is the 2nd button of the 3 buttons in the top right hand corner).

      (3) In the 2nd step of creation of layout arrange the charecteristics in the proper order( parents first with the child coming next).

      Now when you finally creater web interface using this layout you can see the hierarchy where you can expand and collapse .

      You will find out more from the application help under "Manual Planning".

      Thanks,

      Priyadarshi

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.