BusinessObjects Board

extra colom is displaying in crosstab report

building reports desktopintelligence
#1

hi all,

i am created cross tab report with two dimensions( say A&B),one date (date),one measure. my report is displaying only the bands which have data in the database.if their is no data for that combination it is not displaying that combination in the report but i need to display all the combinations eventhough their is no data

for ex:----in dimension A(A,B,C,D,E)
dimension B (U,V,X,Y,Z)

presently my report is displaying like this
date
dim A dim B
A U
X
C Z
U
Y
E V
X
Y
Z

but i want report with all combination like this
date
dim A dim B
A U
V
X
Y
Z
B U
V
X
Y
Z

etc…

i am trying to apply outer join in universe but it is not working
my joing condition between dimensions and fact is

in universe join box i am enabled outer join check box but in join condition box it showing:—(i am using outer join with between operator)

Fact.objectA between dimA.object1 and dimA.object2
fact.objectB between dimB.object1 and dimb.object2

IN MY report dimensions are coming from two different derived tables

i am using BO6.5,AS400

regards
srinivas

srinud81 :india: (BOB member since 2006-07-04)

#2

Read this post

.

haider :es: (BOB member since 2005-07-18)

#3

Srinu,

        Run a different query only with the Dimension objects in result pane and all the conditions you are using in your query. Now in the report use the dimension objects from query2. You should get all the different possible values for those dimensions.

Regards

ay1224 :us: (BOB member since 2007-07-30)

#4

Or have a look at this Reporter FAQ. It describes how to solve a similar problem with missing months for which there is no data in DB.

Marek Chladny :slovakia: (BOB member since 2003-11-27)