Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Update Report month /Qtr/ Week filter automatically

Hi All,   I have a report with Month ,Quarter and Weekly tabs with Month, Qurter and Week filters respectively. My report data will change based on the selected filter. My requirement is to show th...
Need Help
Show and Tell
Tips and Tricks
Sachy123's avatar
Sachy123
Helper V
8 years ago

How does your Datamodel look like? Do you have a Separate Date Table?

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Sachy,

 

I'm using Azure analysis service cube and it is having Date dimension table which is joined to other dimension tables.

 

Thanks & Regards,

Rajeev

  • Sachy123's avatar
    Sachy123
    Helper V
    8 years ago

    Can your client live with something like "Current Month" as a default? 

    • venetsa's avatar
      venetsa
      Frequent Visitor
      4 years ago

      Yes, how can I create that? Also you mean that can I set up a specific current month date/week witch update every day based on today's date?