October 27, 2015 at 5:33 pm
hi All,
I have an requirement .Please help me
I need to create a drilldown excel report by using storedprocedure ,the data tables are in the stage database and i shldnt not use cube or the ssrs report to get the excel report. i am unable to write the procedure for this.Help will be appreciated.
October 27, 2015 at 5:52 pm
Are you using PowerPivot? Sounds like a homework assignment... what have you tried?
October 27, 2015 at 7:34 pm
Ya i can use pivot table but i not getting the query script for the stored procedure here is the scenerio if i click on the product it should drill down to subproduct
October 27, 2015 at 11:17 pm
You have to modify the connection to the database.
How to use a stored procedure for the source of a table in PowerPivot.
1. Go to the DATA tab.
2. Go to From Other Sources.
3. Specify your Servername. Something like HOSTNAME\INSTANCENAME in the "Connect to Database Server" wizard.
4. Select the database you want to connect to.
Modify the Connection Properties. On the Definition tab, change Command Type to "SQL".
Change the Command Text to
EXEC databasename.schema.StoreProcedureName 'parameter1value', 'parameter2value', e.g.
EXEC "SCRIDB"."dbo"."DemographicsSummary" 'LUN90'
"SCRIDB" is my database,
"dbo" is schema the stored procedure is in,
"DemographicsSummary" is the stored procedure name,
and 'LUN90' is the parameter value I wish to pass to the stored procedure (to filter the dataset).
October 28, 2015 at 10:43 am
Hi thanks for the reply ,but here is the thing I shld not give any paramaters to that if I double click the product column it should got to next tab or it shld be drill down in the pivot or excel tables
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply