I am new to SSAS and after trying for hours to solve this problem I asking here.
I have a msOLAP cube that I want to import into SSAS PowerBI
but due to large database I want to pre-filter it befor importing.
The cube has measures in cpe_fact
table and many other dimensions i.e. dim_time, dim_product, dim_material
etc...
What I am trying to achieve is getting all the fields from the fact table joined with a subset of dimensions (i.e. only dim_time
and dim_product
) and filter them by date (i.e. cpe_fact.sale_date < now-6 month)
I tried to put this as MDX query but could not get any data by usin this MDX:
SELECT
{ [CPE_FACT].[MAIN].[SALES_Q]} ON COLUMNS,
{ [Selected_Date].[POSTING_DATE] } ON ROWS
FROM [CPE_Analytics]
I get this error: cube either does not exist or has not been processed evewn before I had a chance to define the WHERE part.
I tried DAX :
evaluate(filter('CPE_FACT', [AGENT] >= "26003"))
it worked but only for CPE_FACT table but i didnt understant how to join with the other dimensions...
My Question: How can I import some Facts Join Few dimentions from the Cube? Example SSAS Connection -