You're talking about two different things. XMLA is not an alternative to SQL, you use it to (amongst other things) process cubes. If you want to dynamically process fact dimensions...

VRT (6/30/2015)

---

Thanks a lot.

I am able to work with it.

yeah 🙂 its hard way and this is how the requirement is.

There is another challenge. can I use the...

VRT (6/30/2015)

---

Its now working fine. Thank you.

now the next challenge, Can I read this variable in Data Flow source tasks.

I created a OLEDB connection to oracle database.

I want to...

Because of the (correct) design of your dimension what you are seeing is distinct composite key selections. The easiest way to get around this is to introduce new attributes in...

Apologies the previous link is misleading. In order to do this correctly you need to create an ADO.NET connection manager to your cube and then choose ".Net Providers for OleDb\Microsoft...

Firstly, use the ordinal number for your result; this would be 0. Secondly just make your variable a string.

Just process the entire cube object with an analysis services processing task. If you add any dimensions then it'll pick them up

You can use an Execute SQL task to run MDX. An example is here: https://gqbi.wordpress.com/2014/04/03/ssis-using-sql-server-analysis-services-ssas-mdx-query-into-variable-in-execute-sql-task/

Can I ask why you are using this DMV query and then processing each dimension, one at a time, in a foreach loop? It would be far better to use...

Nested conditional operators are described quite well in the following url by "SQL Chick": http://www.sqlchick.com/entries/2011/6/8/nested-conditional-operators-in-an-ssis-derived-column.html

This'll do it:

WITH MEMBER [Accessories]

AS

CASE WHEN [Product].[Product Line].CURRENTMEMBER.MEMBERVALUE = 'Accessory' THEN "Accessory"

ELSE "Non Accessory"

END

SELECT

{[Accessories],[Measures].[Internet Sales Amount]} ON 0,

[Product].[Product Line].[Product Line] ON...

smrobin (6/11/2015)

---

Hello Everyone,

I have a fact table that has some basic totals: Order Quantity, Order Dollars, Return Quantity, Return Dollars, etc...

I have about 5 dimensions for that table as...

Here's how to do it using a script task in the data flow:http://bi-polar23.blogspot.co.uk/2008/06/splitting-delimited-column-in-ssis.html

If you're querying a table just do the split in SQL. There's loads of information out there on doing this, including here: http://www.sqlservercentral.com/blogs/querying-microsoft-sql-server/2013/09/19/how-to-split-a-string-by-delimited-char-in-sql-server/

scott.marquardt 58097 (6/4/2015)

---

I'm a newbie at SSAS and I've been having a similar issue with dimensions failing sporadically. When we process a cube, there are some errors that occur when...