How to do operations at year level in dmr reporting

[inu]

Hi Team,
I have year prompt, i used year level, its displaying 2016 to 2050.
But i want to restrict that , year <=extract(Year, current_date).

How to do in slicer, or any other approach, we can do it, please suggest.



Regards,
Inam

[New_Guy]

Hi,
We cannot use less then or greater for the members, instead we can use dimensional functions like periodstodate. Please check the dimensional functions in the data item expression window. Let me know if you still need help.
Good luck
New Guy

[inu]

Hi,
We cannot use less then or greater for the members, instead we can use dimensional functions like periodstodate. Please check the dimensional functions in the data item expression window. Let me know if you still need help.
Good luck
New Guy

[quote author=Inu
Yes, i have clear concept on dmr reporting, i am asking that , how to get that output, you told that , check function, then why should i ask here.

Dont mind please.



Regards,
Inam

[New_Guy]

Hi Inu,
Not a proble and Sorry about that, I will try to reply to the posts as much as I can from what I know and the time I have.

Using a macro you can construct a MUN in a data item and use that to get a set with periods to date and use that set in the prompt.
The place I work has flags saying current period attribute for the time dimension members as 'CM', 'CY' for current periods and 'N' for the previous periods, then we will use a detail filter as [Time dimension].[Current period] in ('CY', 'N') to bring in the members till current year.

Let me know if I am still wrong.

Good luck
New Guy.

[bdbits]

If your prompt is based on a query, you can use the same functionality you would with any query (e.g. a slicer or a filter() expression) to limit the result set.

But please, for dimensional data, never use detail filters. Thanks.

[Deep750]

HAvent been working with DMR for many years, but here is a suggestion, if you have relative time members:

filter([YEAR-level], roleValue('_memberCaption', [YEAR-level]<= roleValue('_memberCaption', [currentYear]))

haven't checked the syntax, so please check it before implementing ;)

[inu]

HAvent been working with DMR for many years, but here is a suggestion, if you have relative time members:

filter([YEAR-level], roleValue('_memberCaption', [YEAR-level]<= roleValue('_memberCaption', [currentYear]))

haven't checked the syntax, so please check it before implementing ;)

How can i create relative time , can you please explain it.

[inu]

How to achieve current year, the syntax you provided, each and every word is important to be understood by me. because this is dmr, to get tiny item as well , we have to suffer a lot.