1 of 1 people found this helpful
You can create a simple calculated member using the MDX query then drag it in the filter.
MDX for today:
[Time] is the time dimension name- change according to your dimension name
[Date] is the date field in time dimension- change according to your field name
"yyyy-MM-ddT00:00:00" : you have to change to your date format.
Drag the date dimension to the filter then choose Today in filter:
Hope this will help you!
Unfortunately with analysis services cube we cannot create a packaged workbook (Connection will be remote). (Analysis services offline cube can-but I think only 0.0001% people have it)
Ok, Thanks Indumon,
Yes, i worked on that few months ago on client side & never tried that to publish it somewhere that is why i do not remember that thing.
Great Thanks a lot,
It was very helpfull but do you how can be the query modified to show ycurrent month or year?
Thanks a lot!
Is there a way for me to display today's date?
In my use case, I have a cube where the latest date may be T, T-1, T-2, T-3, etc...
I need to show the latest date.
I used the Tail function to get the latest date to create calculated member, however there is no way to actually display what my latest date is in the cube.
In another case, I would like to show only the latest 10 dates. Applying conditional filter uses a default date format which is not the format in the cube. Format is cube is 'yyyy-MM-dd' & is a string. In filter Condition, Tableau does not allow to concatenate string when I tried to use datepart.
Any help is highly appreciated..