Grouping on a Variable in B.O.

Posted on 2011-04-25
Last Modified: 2013-11-15
I created a simple WebI crosstab report; that displays counts by month for 10 catagories.
Then I created a variable that groups the 10 catagories into 3 groups.
When I try to display the data by month and use my variable as the other axis to group on; i get "#UNAVAILABLE" displayed in the data cells.

How can I create a variable in a WebI report; and use it as a heading in the crosstab report?
Question by:Orange-County-Joe
    LVL 3

    Accepted Solution

    It's most likely a problem with your variable formula. Use if then elseif else to do the grouping.

    I tested this on WebI in Business Objects XI 3 using the eFashion test universe.

    I created a cross tab with month on the y axis and product lines along the x axis and the sales revenue as the measure.

    I then created a dimension variable called Lines_grouped similar to the following to group the product lines dimension:

    =If [Lines] = "City Skirts" Or [Lines] = "City Trousers" Then "City Wear" 
    ElseIf [Lines] = "Dresses" Or [Lines] = "Jackets" Or [Lines] = "Overcoats" 
    Or [Lines] = "outerwear" Or [Lines] = "Shirt Waist" Then "General Clothes" 
    Else "Other"

    Open in new window

    I replaced the Lines dimension with my Lines_grouped variable and it grouped the report into City Wear, Other Clothes and Other as I intended.
    LVL 100

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now