Question:
Hi all,
I have two different queries in one cube. Is it possible to show one query in graph and one in a table in one web template.
Thanks & Regards,
AMU
Answer:
Yes.
When you add the second object (e.g., Table) to the template, it will default to the same DataProvider (query) as the first object you added (e.g., Graph), but you can change it to use a different query.
Bob
Answer:
Dear Bob,
When we change the query of second object automatically first object query also automatically getting changed . It is not allowing to keep two different queries. It is in Version 3.0b
Thanks and Regards.
Amu
Answer:
Technicall Yes
Logically make sure both gotta have some relation, so as to reflect changes from table to graph.
Remove option of affected data providers from query 2 web item properties
Chetan
nJOY SAP
Answer:
Click on second object, then create new DataProvider for it (Name = DATAPROVIDER_2 by default) and choose a second query.
BTW -- This is all covered in the SAP Web Reporting class (recommended), or the on-line help documents (help.sap.com).
Bob
Answer:
Thanks Bob and Chetan. I got the solution . Sorry for the trouble.I am new to web reporting.
Answer:
Then I would suggest looking at this:
http://help.sap.com/sapdocu/netweaver/bw/bw30b/helpdata/EN/a9/71563c3f65b318e10000000a114084/frameset.htm
It should give you enough information to get started w/ basic web reporting. It provides more complete documentation then other areas of BW.
- Stephen