13 month report

[pooja]

Hi all,

I am working on cumulative 13 month report which basically display last year DEC data to current YTD data based upon period selection.
Like - if user select MARCH 2014 then output should be DEC13-JAN14-FEB14-FEB1-MAR14.........DEC14

So this is what I used.
periodstodat([cube].[period].[month], [selectPeriod]. But this gives me only current YTD, not last year DEC.

Could you please guide me how to get prior year DEC data too?
We are using dimensional model(cube).

Thanks,
P

[Francis aka khayman]

is the user selection limited to current year? (March 2014 in your example)

or can the user select last year month? (March 2013 for example)

[pooja]

User can select any period in prompt selection. 
another scenario - if user select DEC 2010 then output should be 13 month data from DEC 09-JAN 10- FEB 10-MAR 10- APRIL10-MAY 10.........to...........DEC 10


Hope this is clear.

[MFGF]

Hi Pooja.

Isn't this the same question you asked here:
http://www.cognoise.com/index.php/topic,24850.0.html

Why start another thread? Why didn't you answer the questions asked in the first thread? Why post requirements if you're not going to respond fully to questions other forum members ask you when they are trying to understand your requirements?

We have been through a number of your requests for help with dimensional reporting, and each time we suggest you think of the structures in terms of hierarchies. How far have you gone through this thought process in this instance?

If you have a selected month, it will have an ancestor somewhere above it in the year hierarchy, right? If you use a function to locate that year member (you know which function to use because we covered this before), then you can find all of its descendants at the month level (again, you already know what function to use to get the descendants of a member at a level).

This will give you all twelve months belonging to the year of the month selected in the prompt.

Now all you need is to get hold of the month prior to the initial member in this set, and add it into the set. How do you get hold of the initial member? I'd suggest an openingPeriod function. How do you get hold of the member preceding this? Maybe a lag() or prevMember() function. How do you add this member to the set of 12 you already have? Use a union() function.

You have all the pieces here to code the solution. Please don't ask for step-by-step - you are experienced enough to be able to figure this out. it will be a good learning exercise for you and it will help you to be able to write other dimensional reports without needing to resort to asking for help on Cognoise. Who knows - maybe you will be able to start posting helpful solutions to questions other members ask?

If you get stuck, we will of course assist with specific problems.

Good luck!

MF.

[pooja]

MFGF,

I have got lot of help and knowledge from this forum. No doubt about that and I believe other members does too. This is the best Cognos forum that I know as of today.
There were never ever I had intention to post same issue again and again, also I never expect someone is going to post step by step solution of my issues.
And with due respect this is not the same post that I posted earlier. This is different.


P

[MFGF]

MFGF,

I have got lot of help and knowledge from this forum. No doubt about that and I believe other members does too. This is the best Cognos forum that I know as of today.
There were never ever I had intention to post same issue again and again, also I never expect someone is going to post step by step solution of my issues.
And with due respect this is not the same post that I posted earlier. This is different.


P

Here's an interesting statistic from the Forum Stats page



Look who is at number two! :)

That *is* an awful lot of help you've been given over the years, from many, many members. Maybe food for thought is how many of those posts are volunteering help to others?

You are a long-standing and valued member of this forum and we always enjoy seeing you on here. If you could also find a little time to help others by answering questions based on your knowledge and experience it would be a wonderful thing. People look up to senior members such as yourself, and helping them would be a noble thing indeed! :)

Cheers!

MF.

[pooja]

Thank you MFGF.

That is amazing.
Going forward, I will try not not to post any thread if possible. It looks like this forum has been made only to resolve my issues.


Thanks,
P

[MFGF]

Thank you MFGF.

That is amazing.
Going forward, I will try not not to post any thread if possible. It looks like this forum has been made only to resolve my issues.


Thanks,
P

That's not what I was saying - just trying to encourage you to post in more threads and help others. As I said, you are a valued member, pooja :)

MF.