on 02-15-2010 10:00 PM
Hi experts,
I have a Webi report based on OLAP universe.
I'm facing few problems while sorting .Here is the problem
Eg:-Emp Number
5,8,10 ,11,22,82.
Ascending result:-10,11,11,5,8,82.Its behaving like this because Emp number is changed to Char in Universe level.So,the values of emp numbers are having as a string.
I tried to change the Emp Number type char to Number in Universe level-It's throwing driver incompatiable error when running webi report.
When I tried to use ToNumber in report level-It's giving #Error values in all columns.
Please guide me for the solution.
Thanks
Hi Tanb,
Try this =ToNumber(Replace([Object Term]);",";"")
Thanks,
Mayuri W.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Got the answer....
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 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.