splitting table in web template

[Former Member]

Hi guys

we have one template where one table shows both planned and unplanned data...now we want to change it in a way where planned data and unplanned data is shown in two different tables and the old table should be taken away...

we differentiate planned and unplanned data in multiprovider and cubes by means of one attribute...this is there in queries also...How can I do this to get two tables...Thanks...

Rgds,

p olin

[former_member241911 · Accepted solution]

Hi,

you just create two queries, one for the planned and one for the unplanned data.

In the webtemplate use two dataproviders and two analysis items (maybe the 2nd without Headers) and put them into a container layout item and arrange them side by side.

But it is not possible to navigate in one table and let the 2nd navigate automaticly in the same way.

regards

Arne

[Former Member]

Hi authors,

Thanks for your reply.I will create two queries.We have one infoobject that distinguishes 'Planned' and 'Unplanned' data...so I put this infoobject in characteristic restrictions panel and restrict in first query on planned data and in other query ,restrict this infoobject on unplanned data....This should give two queries ...one showing Planned data and another Unplanned....these two queries can be used as dataproviders for two table items....this should work.Am I right?

Other thing is in my webtemplate..I have some 'Export to Excel' option where I see Excel icons like....Graph1...Graph2..Table1...etc...when I click on them ..I am getting data whatever is presented through webitems in the form of excel sheet...how can I add two more excel icons which exports data from above two table webitems I am going to add by deleting old table web item.....

Thanks for your help.

[former_member241911]

Hi,

the Excel export command with standard parameters export every exportable item as you recognized.

Please lookup [Note 1178857|https://service.sap.com/sap/bc/bsp/spn/sapnotes/index2.htm?numm=1178857].

Exporting only some visible items requires to name them as parameters for the export command.

Regards

Arne

[Former Member]

Hi,

You can assign the same query to multiple dataproviders as well, and assign each data provider to a analysis item/table in WAD, and try executing the template. It should work.

Regards

Snehith.