Expanding and collapsing to show totals and subtotals

[former_member338469]

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

[former_member338469]

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

[Former Member]

Priyadarshi,

I do not remember for WIB but in Excel Layouts there is a setting in Layout builder where you can display as totals for one or more set of characteristics.

Akash

[Former Member]

Hi

In GUI version, you can use the excel functionality to achieve this. Go to third step of Layout builder and on excel tool bar>>>data>>>Group and outline, and you can group the colomns you want but this is not working on web interface.

Thanks,

Raj.

[former_member338469]

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

[Former Member]

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