Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: WKar on 20 Mar 2009 12:48:32 PM

Title: Report displays different column orders at different times running it
Post by: WKar on 20 Mar 2009 12:48:32 PM
Hello - See the 4 attachments, i have to post them separatley it seems

The one that says behaving the latest version is how the report should look:

Note the situation.  No one is loading to the tables, the data is constant, but in the span of a week.. we ran this report 3 different times/days and our Months go out of order, and our quarters go out of order.  Why is this happening?? The very last time we ran it, it worked.  We cannot put logic to it.  Also attached is the specs of my report. 

It seems that it wont let me attach all 4.. ill post 3 more times to get all of this out.

Please advise thank you!
Title: Re: Report displays different column orders at different times running it
Post by: WKar on 20 Mar 2009 12:49:51 PM
second attachment
Title: Re: Report displays different column orders at different times running it
Post by: WKar on 20 Mar 2009 12:50:34 PM
third attachment
Title: Re: Report displays different column orders at different times running it
Post by: WKar on 20 Mar 2009 12:51:06 PM
report specs
Title: Re: Report displays different column orders at different times running it
Post by: WKar on 23 Mar 2009 10:33:43 AM
Also, something to add that may be my problem, is that I am using

firstchild  to get Q1
and then next member(Derived Q1) = Q2
next member(Derived Q2) = Q3
next member(Derived Q3) = Q4

would this throw off the order occasionally?  What makes it confusing is that it will run perfectly fine and then randomly get out of order.. and then run fine..

Please help. thank you

Title: Re: Report displays different column orders at different times running it
Post by: rockytopmark on 24 Mar 2009 05:23:02 PM
use the Order() function to properly order your quarters
Title: Re: Report displays different column orders at different times running it
Post by: WKar on 24 Mar 2009 05:37:08 PM
the 4 quarters are 4 diff data items.

and then the code is as i listed above to get to each.

where do i put the order function? Do I create a 5th data item and place on top? or is it within the code of each of the 4 quarters?

thanks for the reply, let me know
Title: Re: Report displays different column orders at different times running it
Post by: DSR on 25 Mar 2009 02:27:05 AM
Hi,

Try this solution once....I think all months are sitting in one column..

If this is the case better to use one condition in calculated data item which says like...

Case when [Mon]='Jan' then '1'
        when [Mon]='Feb' then '2'
.................. end

and for quarters

I think you are using cross tab to display months....If these quarters are different columns you will get all the colums ordered as per the columns droped in report (cross tab) at the time of report creation....

Please check this once... if your getting all the quarters data from a single column or calculating from the months then you need to put same kind of logic as mentioned above for months.

Let me know the situation..........

regards
Sanjeev
Text only | Text with Images