Filter in Dimensional Reporting

[sunny bachan prasad]

Hi Cognos Guru,

I am using dimensional package for my report.
Our data in the database is present for the past three months for certain number of client .Now user has a requirement in which they want to select a particular client from the prompt page and report has to run for the most recent month for which data is present for that particular client. I was able to implement it through the java script but now they dont want to use java-script.

Please share your experience.
Thanks in advance. :(

[cognos810]

Hello sunny,
Assuming [Sales] is a data item for which values are present only for current/or past months, you could try something like,
ITEM(
TAIL(
FILTER([MONTH_LEVEL],[Sales] <> 0)
)
,0)
and then drag this data item into the slicer area in the query.

Will it work for you?

-Cognos810

[sunny bachan prasad]

Hi Cognos810,
Thanks for your time.
As per my understanding the code which you have written will filter the month level for which sales >0.But i am getting one doubt here please correct me if i am wrong (i am not aware how TAIL function)how cognos will know that it has to select the recent month from the prompt in this case current months?

[cognos810]

Hello Sunny,
The prompt is on a client and not months right? That is what I got from your first explanation.

-Cognos810

[sunny bachan prasad]

Hi Cognos810,
I think i am not able to explain properly.I have attached the excel for the proper understanding and have taken that as a reference.
Here client and date d1 and d2 is coming from two different dimension.Req is like that if the user will select C1 in the prompt page then prompt p2 wil have to show only the date which is present for the client C1. In this example it will be 201411,201410,201409 and once user will select date from prompt2 it will show only the date related to prompt2.For example if user will select C1,201409 from prompt 1 and prompt2 respectively then third prompt should come up with 11/10/2014,12/10/2014,13/10/2014,31/10/2014 and should automatically select the most recent date from the prompt in the present sceneraio it will be 31/09/2014.As i mention earlier i am able to do this with the help of java script with client is not agree with the java script.

I tried my best this time to explain my self but please let me know if you need any other infromation from my side.
Thanks in Advance.