cancel
Showing results for 
Search instead for 
Did you mean: 

issues facing with custom sorting

Former Member
0 Kudos

Hi Experts ,

I have to create a bar chart in WEBI in which i need to show age buckets (0-2 ,3-5,6-10,11-20,31-45,46-60,60+) on X Axis (Dimension Age) and count of requests on Y Axis(count of requests created that is a measure).

X axis(Age bucket) i am populating based on a variable that is computed based on Age dimension(lets say "Age bucket") .

Now i apply a custom short on Age bucket and drag my measure on Y Axis.

Now issue is i want my X Axis to be populated fully (ie all the age buckets should be present in X axis even if count of request is 0).

But as Age_busket is calculated on run time , i get only those values for which there is some count (say 0-2 , 6-10 ,60+) rest all (6-10,11-20,31-45,46-60)does not come on X  axis if count is 0 for them

Any work around by which i can populate whole X Axis (0-2 ,3-5,6-10,11-20,31-45,46-60,60+)...even if count is 0 for any age bucket .

refer attachment for your reference.

Thanks in advance!

Regards,

Saurav

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I have a small workaround for this:

In Universe create:7 objects as:

objects name  0-2: in select '0-2'

3-5 : in select '3-5'

6-10: in select '6-10'

11-20: in select '11-20'

Now add new query to webi report and add one dimension that is unique at db that you can use for merge.

in this new query add combine query and add 7-8 combine queries.

In each combine queries: you can add dimension and the objects created say in combine query1: add d1 and 0-2 object

in combine query2: add d1 and 3-5 object.

Now use the 0-2 object created out of this query for your reporting.

Please give it a try and let me know how it goes.

Cheers,

Kiran

Former Member
0 Kudos

Hi Kiran

Could not get completly what you mean by this :

What do you mean by this :

objects name  0-2: in select '0-2'

3-5 : in select '3-5'

6-10: in select '6-10'

11-20: in select '11-20'

Former Member
0 Kudos

Create Objects with name

0-2,3-5 ..

and in the select clause of object specify string  '0-2',3-5.. respectively.

And use these objects in the combine query as stated earlier.

Hope this is clear now.

- Kiran

Former Member
0 Kudos

Hi

I was able to achieve this through derived table ....

A few hour effort but successful

Thanks,

Saurav

Answers (1)

Answers (1)

gleo_SRAM
Active Contributor
0 Kudos

Hi Saurav,

If you source is a BEx query, you can create a structure in your Bex query that has those selections.

Be sure that you do not enable Zero Row/Column suppressions on your structure,

With regards

Gill

Former Member
0 Kudos

Hi Leo

It has BO universe built on a relational datasource.