Skip to Content
author's profile photo Former Member
Former Member

Hierachy in the report incuding previous periods

Hi, guru.

I have a problem with my report which based on the info-set.

This info set consist of:

1. Info cube Z_CUBE

2. Info-provider Z_OLD_OE with time-dept. navigation attribute 0ORGUNIT

3. Info-provider 0ORGUNIT with some attribute Z_ATTR and time-dept. hierarchy structure

You can see it on this picture [Schem|http://s011.radikal.ru/i318/1201/a6/d9d202d93e1e.png]

My query filters this characteristics: 0ORGUNIT, 0CALYEAR, 0CALQUART1. The query's key date is set to last date of the quarter(e.g. you choose 3 quarter of the 2011 - it will set to 30.09.2011). Date for the hierarchy also is set like a key date.

So, the problem is:

if some of the orgunits were closed in the previous quarters, I can't see any their data, even if query has some growing ups (e.g. some calculated KF making a total from the first quarter to the selected quarter, 1..3)

What should I do, if I need to see all Orgunits (closed and not) and their data?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 05, 2012 at 01:33 AM

    Just a suggestion. If you are using a temporal join on the ORGUNIT, it might be needed made basic LoJ. And, in the query, ensure no restrictions affect this Infoobject in any of it's restrictions.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.