-
1. Re: Analisys Services Today filter.
Prashant SharmaNov 27, 2013 9:48 PM (in response to Luis Fernando Paredes)
Hi Luis,
Please attach the sample file of your datasource(.twbx), so that we can understand your problem clearly.
Warm Regards,
-
2. Re: Analisys Services Today filter.
. Indumon Nov 28, 2013 2:48 AM (in response to Luis Fernando Paredes)1 of 1 people found this helpfulHi Luis,
You can create a simple calculated member using the MDX query then drag it in the filter.
MDX for today:
Strtomember("[Time].[Date].&["+ format(now(),"yyyy-MM-ddT00:00:00")+"]")
[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:
Final output
Hope this will help you!
-
3. Re: Analisys Services Today filter.
. Indumon Nov 28, 2013 5:00 AM (in response to Prashant Sharma)Hi Prashant,
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)
-
4. Re: Analisys Services Today filter.
Prashant SharmaNov 28, 2013 5:19 AM (in response to . Indumon)
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.
Warm Regards,
-
5. Re: Analisys Services Today filter.
Luis Fernando Paredes Nov 28, 2013 6:10 AM (in response to Luis Fernando Paredes)Great Thanks a lot,
-
6. Re: Analisys Services Today filter.
Tereza Stloukalova Aug 10, 2015 6:27 AM (in response to Luis Fernando Paredes)Hi all!
It was very helpfull but do you how can be the query modified to show ycurrent month or year?
Thanks a lot!
-
7. Re: Analisys Services Today filter.
Chandra Shetty Jun 6, 2017 1:11 PM (in response to Luis Fernando Paredes)Hi,
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..
Thanks,
Chandra