xmla

Use Results of an XMLA query in Integration Services

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...

script task using XMLA

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 ...

Automate deployment of XMLA / documentation on Microsoft.AnalysisServices.Xmla

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...

Prevent Visual Studio Web Test from changing request details

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...

How to query (xmla) the size of an OLAP catalog in MSAS2008?

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...

Could not find an aggregator in the current evaluation context

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...

Query olap mondrian (mdx,xmla) with python interface ?

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 ...

What options do I have for creating OLAP cubes with Postgres and making it accessible via .net webservices/wcf?

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...