Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adding date table to mdx query

Hello   In my last post I asked how to correctly pull data using MDX filtering and got everything working. Code that helped me filter out and format it just how I needed: SELECT NON EMPTY {[Proj...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    try this ...

    SELECT
NON EMPTY {({[Project POS].[Type hierarchy].[WinPOS], [Project POS].[Type hierarchy].[SelfCheckout]} * [Time].[Time].[Calendar Year].&[2020])} ON COLUMNS,
NON EMPTY {[Project POS].[POS hierarchy].[Project]} ON ROWS
FROM 
   (SELECT ({[Time].[Time].[Calendar Year].&[2020]}) ON COLUMNS  
    FROM [Property Cube]) 
WHERE ([Measures].[Count of Receipts])

     

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

take a look at this Excel add-in.

https://archive.codeplex.com/?p=olappivottableextend

 

If a PivotTable is performing poorly or returning incorrect numbers, it may be necessary for the Analysis Services administrator to troubleshoot the MDX query which the PivotTable is using. The MDX tab of the OLAP PivotTable Extensions dialog shows you this MDX.