Forum Discussion

NadaBen's avatar
NadaBen
Helper I
9 years ago

dynamic filter

Hello,   I import this table below from BI (Analysis services), this table is huge and i cannot import it entirely, in addition i need restrictred information from it, i want to filter my "snapshot...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Does your cube have a column that's DateTime/Date, or one that can be easily parsed to be DateTime/Date ?

 

Are you able to add columns to tabes in your cube?

NadaBen's avatar
NadaBen
Helper I
9 years ago

Unfortunately no !

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Are you importing or doing a live connect?

    • NadaBen's avatar
      NadaBen
      Helper I
      9 years ago

      I'm importing tables

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        9 years ago

        You can write MDX against both MD and Tabular cubes.  With MDX it's possible to create dynamic date ranges using a combination of VBA and strtomember functions but this is medium to advanced MDX and definitely requires knowledge of your model.