on 2006 Dec 28 11:50 AM
I want to create a table in Visual composer which would have the drill down capability.
i have 2 tables, Master table and Details table.
In master table i have one row and corresponding to that row i have 5 rows in details table.eg., Master table has the over all revenue generation and in the details table i have the revenue generation for each month.
Now the table in VC should show the first row of the Master table and upon drilling down it should the coresponding 5 rows from the details table.
Is it possible with out using BW.
Regards
Paresh.
Hi paresh,
it's possible if you use e.g. a sql 2005 server, therefore you can create also cubes as in the SAP BW. I saw a BI demonstrationon the microsoft raodshow (Vista, Office 2007, Exchange) in december. The new office version has excel webservices similar to the queries. maybe it's possible to use sql2005 server in combination with the excel services, but I never tried it. Maybe I try it after my vacation in january.
Best Regards,
Marcel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marcel,Mario
Thanks for your Immediate reply.
I want the master data and details data to come in the same table.
To be clear, intially the user would see one row and upon clicking that it should open up to show the others records from the details table.
So i think it could be possible by the method you told.
So please after you have done, give the steps in detail about how to achieve it.
Regards
Paresh.
I am not sure if I understand your question.
1) Drag two data servcies on your story board, one with master data, the other one with detail information.
2) Create tables from the output ports for each dataservice.
3) Connect the output port of the table of the firstdata service with the input port of the second data service
4) Map the fields (like e.g. material number)
5) create a start point to the input port of the first data service
6) deploy and launch the application
OK, I see. You basically need a data service that allows you some flexibility, like the BI data service with the Web API.
For JDBC this would be the SQL Field (you need to turn that on first, see also the documentation for that feature) and fire SQL statements corresponding to your selections.
For the other services it might be just passing the selected parameters, but you have ot much influence on the structure then. It might just filter down to the value that you had.
Be aware that the data must come from the same data service.
Mario,
I'm creating some PM Metrics using Visual Composer and BW Queries. My overview or summary Metrics will be by Company Code,, and I can get those results but if I have a strange number or value for a particular Company Code, I want to be able to click on that line and look at the Maint Plants and the values for that particular Company Code. Do you know if this is possible?
Mario,
thanks for replying, but I haven't got this to work. I'm using 2 queries: 1 by Company Code and 1 by Maint Plant. Then from the Output table on Company Code, I connected it to the Input on the Maint Plant query, and then on my connection line I chose Submit.
My results come back by Company Code, but when I click on a particular Company Code line I don't get any results by Maint Plant.
What am I missing? Could you provide screen shots on how this should work?
I assume you have in both queries the same infoobject and this infoobject is connected in the connection line?
Query1 Output -> Input Table1
Table1 Output field -> Variable or Filter of Query 2
Query 2 output -> Input Table2
If you use Company code, then you have to connect the company code field from Query 2 to the output of table1.
You can send me a screenshot of your model under my sap email address (firstname.lastname@sap.com)
User | Count |
---|---|
81 | |
11 | |
10 | |
10 | |
10 | |
8 | |
7 | |
7 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.