I have an XMLA query which returns the State and Last Processed date of an Analysis Services cube as XML, like so:
Query:
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_METADATA</RequestType>
<Restrictions >
<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis">
<DatabaseID>S...
Hi Nagendra
Please help me.
You can show me an example of your sript task, I need it urgent.
I refer to this subject
http://stackoverflow.com/questions/490059/use-results-of-an-xmla-query-in-integration-services/748931#748931
...
I'm looking to automate the deployment of XMLA scripts. I've come across an article that gives a small demo, but I'm hoping to find more info.
Specifically, where is the documentation for Microsoft.AnalysisServices.Xmla.XmlaClient and what is the best approach for overridding the database and connection values that are embedded in the X...
I have a service that accepts Xmla queries for Analysis services, often times those queries themselves will have a string that contains a fragment that looks something like
{{[Time].[Year].[All]}}
Recording these requests works fine but when I try to re-run the test I get an error from the test runner...
Request failed: Exception oc...
I would like to be able to query against an SSAS2008 instance and get a listing of all the catalogs that exist in it, as well as their respective storage sizes. In Management Studio, I can right click on the catalog and go to its properties, which retrieves this data, so I know it exists somewhere. A query that has some of the informat...
Hi, I have a mesurement which is an average and it mapped as a CalculatedMember to support aggregate tables:
<Measure name="AverageFullPercent_sum" column="fullDockPercent" datatype="Numeric" aggregator="sum" visible="false">
</Measure>
<Measure name="AverageFullPercent_count" column="fullDockPercent" datatype="Numeric" aggregator="coun...
Actually i'm using R + python with RPY2 to manipulate data and ggplot to create beautiful graphics.. i have some data in postgresql database, and i'm using psycopg2 to querying data.
I'm starting thesis, and in the future i need OLAP cube to store my (very big) simulation data : multiple dimension, aggregation query, etc.
Is there any ...
We have a large POSTGRESQL transactional database (around 70 million rows in all), and have previously created a data warehouse from this (updated daily) to run reports off of.
To make this more flexible (as lots of different users require different reports and aren't very good at specifying what they want) we would like to create a mul...