View Complete Post
i need to implement current scenario:
1. the report will have an ID as input parameter
2. according to this ID it will pull out an XML from database table
3. use the XML as data source
and I have no even an idea where to start.
Could anybody be so kind and help me with this?
Thank you in advance
I have installed SQL Server 2005 with Database Engine and Analysis Services both utilizing the DEFAULT instance. I also installed all the sample databases from the Advanced option.
When I connect to Database Engine, I can see both 'Adventure Works' and 'Adventure Works DW' databases.
When I connect to Analysis Engine, I DO NOT see any databases. I was expecting to see 'Adventure Works DW' .
Thanks in advance for your help :)
can't connect to an excel services data source on the sharepoint 2010
Error : ... can't connect to external datra source .....
I am getting below error when I click Slicer in excel 2010 powerpivot chart.
An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh:
I am using SQL Analysis services cube to fetch data into my powerpivot using windows authentication mode.
Appriciate any help.