Hi
Hope anybody can help me and my question is reasonable.
In Power Query I connect to a new source with below string. The SQL string within includes here 3 Account IDs (RC Number).
But I do not want to have fixed accounts in the query. The query should be flexible and pull the accounts from another table within power query. In addition the number of accounts might be different (not 3 always but 5 accounts) which I query.
Original Query
= OleDb.DataSource("provider=MSOLAP.8;...", [Query="SELECT {[Measures].[Sell Out Quantity],[Measures].[Sell Out Amount]} ON COLUMNS , NON Empty Hierarchize({DrilldownLevel({[RC Account].[RC Number].&[0000159985],[RC Account].[RC Number].&[0000199622],[RC Account].[RC Number].&[0000283464]})}) ON ROWS FROM (SELECT ({[Currency].[Currency].&[EUR]}) ON COLUMNS FROM [Data-CUBE]) WHERE ({[_Empty Cube].[Empty Cube].&[No]},{[Sell Out Data].[Data Source].&[SellOutFiles]},{[Sell Out Data].[Sales Doubled].&[N/A],[Sell Out Data].[Sales Doubled].&[Not Sales Doubled]},{[Sell Out Data].[Sales Type].&[N/A],[Sell Out Data].[Sales Type].&[Sales]},{[Sell Out File Data].[Flat File Type].&[],[Sell Out File Data].[Flat File Type].&[QUO],[Sell Out File Data].[Flat File Type].&[SAL]}) CELL PROPERTIES VALUE"])
Example for table which holds the accounts to be used in above query and might change with a refresh.
| Account Name | Account number |
| Ben | 0000123456 |
| Luke | 0000443399 |
| Fritz | 0000121112 |
Thank you so much for any input and support.
Br/Robert
