on 01-25-2011 1:20 PM
Hi Gurus,
I have two record for one person in the data base with different description. But i want to display this information in Single Row in the Report in WEBI like EMP NO Desription1 Description2 like that. I am using XIR3.1
Any Suggestions
Thanks
BO_Member
Does you have EmpNo, Descr1 & Descr2 as objects defined @Universe??
YES, Drag them to Vertical Table(by default), which BO creates after hitting run query. Align objects how you want to display.
NO, Create Variables where applicable and follow the same.
I'm Back
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes this is a good idea, generate a universe schema there most be have relation between two tables. the relation you know forign key and primary key relation according to there relationship. so create the universe with one to one codrinolity equie(eno--->eno) join and drag the three object(eno, discription 1, discription 2) and export universe.
but,
the database table most be like:
emp table:
eno(primary key__________ename
01______________________praveen
discription table:
disc no__________discripition__________eno
01______________discription 1_________ 01
02______________discription 2_________ 01
All the best.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can build a Cross tab report in webI. Then You can solve your Problem.
Regards,
Narendra.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Choose a table from Templates Tab. It could be the pivot-like table. Then drag and drop person name in the blue cell shown at left, and drag and drop the description dimension in the white cell.
You'll see that users name doesn't repeat, and description 1 and description 2 are shown one beside the other.
Now, to place the title you have to write the word Description in the blue cell that appears above. SInce you want it to say Description 1 and description 2, you'll have to play with column functions. I don't remmeber well, but for titles you could use this formula:
="Description "+ColumnNumber()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.