Skip to Content

Re: additional column problem

Hi Guru's,

Using: SAP BO ENTERPRISE XI Product: 12.1.0

I have created a variable to get the Months_ Age of calender date

=(Year(CurrentDate())*12 + MonthNumberOfYear(CurrentDate())) - (Year([Calendar Date])*12 + MonthNumberOfYear([Calendar Date]))

My requirement is to get the previous 12 months data in a cross tab

for ex:

>>>>>>>>>>>>>>01>>>>02>>>......>>>12{Monts_Age<12}

Division01>>>>100>>>200...>>>>>500

Division02>>>>190>>>290...>>>>>50

for this I created above variable Month_age

and I created one more variable to get only last 12 months

=[Months_Age]Where([Months_Age]<12)

But the problem is I'm Getting an Extra column at the End which is Empty as heading and underneath it showing the values sum(all other values which is not less than 12 months)

>>>>>>>>>>> 01>>>>02>>>......>>>12>>>>>Blank>>{Monts_Age<12}

Division01>>>>100>>>200...>>>>>500>>>>>40000

Division02>>>>190>>>290...>>>>>50>>>>>>50000

I need to get rid of this empty heading values column.

Or Please tell me is there any other possibility, I don't have universe or custom SQL access authorization, i have to do in WEBINTELLIGENCE only

Regards,

Ranganath

Edited by: Ranganath on Dec 9, 2011 11:18 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 08:22 AM

    Hi Ranganath,

    Its seems ,report getting all date range data from your query ,then try to restrict data in report level using variable (less than 12 month) as a column header. ( but there is not filter for this table) thats why remaining data is show end of the table without heading.

    you can resolve this is two way

    1) Apply the filer in report level using Monthage less than 12 month condition. So it will display result as per condition.

    2) Apply the less than 12 month condition in query level if possible.

    Thanks

    Ponnarasu

    Edited by: ponnarasuk on Dec 12, 2011 9:22 AM

    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.