Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Grouping on a Variable in B.O.

Posted on 2011-04-25
Medium Priority
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

Accepted Solution

meumax earned 2000 total points
ID: 37174457
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 101

Expert Comment

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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

564 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