on 04-09-2014 5:56 PM
Hi All,
I have converted reports from deski to webi.
Wanted to check with you guys if the variables were converted correctly or not. Data is not available as such to see if the variable is working correctly or not. Below are the formula's used for creating the variables
=Count(<Emplid>) In (<GSDB Cd> ,<Plan Type>) In Deski
=Count([Emplid]) In ([GSDB Cd] ;[Plan Type]) After Conversion in Webi
=Sum(CountAll(<Emplid> In Body) In (<GSDB Cd> , <Plan Type>)) In Deski
=Sum(Count([Emplid] In Body;IncludeEmpty;All)) In ([GSDB Cd] ; [Plan Type]) After Conversion in Webi
="For Period : " & Max(<Monthcd>) & "/" & Max(<Year>) In Deski
="For Period : " + Max([Monthcd]) + "/" + Max([Year]) After Conversion in Webi
=(CountAll(<Dependent Benef>) ForEach <Plan Type> In <Emplid> ) In Deski
=(Count([Dependent Benef];IncludeEmpty;All) ForEach ([Plan Type]) In ([Emplid]) ) After Conversion in Webi
My question is whether the formula got converted in webi correctly or do i need to modify them.
Ex: Var1 = If <Dependent Benef>>" " Then 0 Else <Dependent Count>-1 In Deski
Var1= If( [Dependent Benef]>" " )Then 0 Else [Dependent Count]-1 In Webi After Conversion
This was leading to "-1" being shown on cell where i was using this variable. So i converted the formula to
Var1= If( [Dependent Benef]>" " ; 0 ; " [Dependent Count]-1") As "THEN" and "ELSE" are replaced in webi With ";" Also " [Dependent Count]-1") is now in double quotes. So now the "-1" is not showing in cell anymore where i am using this variable.
Do i need to do anything similar or something different for the above 3 variables... Please help
Hi Jeff,
Please see this Doceument:
Might help u
Conversion from Desktop Intelligence to Web Intelligence - Business Intelligence (BusinessObjects) -...
1.Objects cannot be hidden in Web Intelligence documents
--JY-Show Objects before conversions and convert them..After conversin, make them white backround
2.Page setup options are not implemented in Web Intelligence (First page number, page order, scale, Fit to N pages)
--You need to Manaully set the settins after conversions
3.cross options for crosstabs are not available in Web Intelligence
4.Block filters on measures do not have the same behavior in Web Intelligence
5.The formula of a global filter in Desktop Intelligence cannot be migrated into a Web Intelligence report filter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
11 | |
10 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.