101
101
Problems
Problems and
and Solutions
Solutions in
in WEBI
WEBI reports
reports
1.
1.
I have one date object which is I have one date object which is Evaluation Date and i created two condEvaluation Date and i created two cond itionsitions Begin dateBegin date and and EndEnd datedate on that object which takes user input,Now i want to display both begin date and End date on on that object which takes user input,Now i want to display both begin date and End date on the report title how can i do that can you tell me the syntax for that
the report title how can i do that can you tell me the syntax for that
Sol:
Sol:
Use theUse the UserReponse()UserReponse() function to get the value entered by a user in a report prompt function to get the value entered by a user in a report prompt2.
2.
lease advice,if it is possible to lease advice,if it is possible to make link from the column values to the image! i make link from the column values to the image! i have "ebi reporthave "ebi report with column #efID and each ID haswith column #efID and each ID has a image associated with that! Is it a image associated with that! Is it feasible! $urrently i%mfeasible! $urrently i%m keping all the images on my local
keping all the images on my local folder!folder!
Sol:
Sol:
I think you can! $reate a I think you can! $reate a variable to define the Image name based on the variable to define the Image name based on the #efID! ut this#efID! ut this variable in the cell which should containvariable in the cell which should contain the image! $hange the property of the image! $hange the property of the cell %#ead cellthe cell %#ead cell content as% to
content as% to Image URLImage URL!!
3.
3.
#ight now I am getting the &' user id through $urrentUser() function! &ut I want to display the#ight now I am getting the &' user id through $urrentUser() function! &ut I want to display the user first name and user last name!user first name and user last name!
*indly help me to get the first and last name of &' login details! *indly help me to get the first and last name of &' login details!
Sol:
Sol:
I havent seen a way to do thI havent seen a way to do th is! &ut if you get the name, is! &ut if you get the name, here is the formula tohere is the formula to seperate first name and last nameseperate first name and last name Code:Code:
First Name
First Name =Substr([Name=Substr([Name];1;Pos([Name]];1;Pos([Name];" ;" ")-1)")-1) Code:
Code:
Last Name
Last Name = = Substr([Name];Substr([Name];Pos([Name];" ")-1;Length([Name]Pos([Name];" ")-1;Length([Name])-Length([First Name])-)-Length([First
Name])-1)
1)
+ope you get the earlier problem solved! +ope you get the earlier problem solved!
4.
4.
I have filleter condintion on tableI have filleter condintion on tableysDeploylan-inish!!!!!!!!!universe object ysDeploylan-inish!!!!!!!!!universe object
D Date!!!! I created variable (user suppose to
D Date!!!! I created variable (user suppose to select date or enter)select date or enter) DE Date!!!!!! I created variable (user suppo
DE Date!!!!!! I created variable (user suppo se to select date or enter)se to select date or enter)
.ysDeploylan-inish/ between .riorDeploytartDate/ and .riorDeployEndDate/ .ysDeploylan-inish/ between .riorDeploytartDate/ and .riorDeployEndDate/ I tried as below
I tried as below
If.D-/between.DD/ and .DED/ then 010 Else 0N0 If.D-/between.DD/ and .DED/ then 010 Else 0N0
Sol:
Sol:
2fter you enter the dates in the prompt for2fter you enter the dates in the prompt for Start Date and End DateStart Date and End Date!! 1ou need to create variables to capture those dates using the1ou need to create variables to capture those dates using the UserResponseUserResponse function in function in the reports and then use those variables in
the reports and then use those variables in thethe If statementIf statement you have! you have! Code:Code:
V_PDSD = Todate(Userresponse("use
V_PDSD = Todate(Userresponse("user suppose to r suppose to select Start date or select Start date or enter:");"")enter:");"") Code:
Code:
V_PDSE = Todate(Userresponse("use
V_PDSE = Todate(Userresponse("user suppose to r suppose to select End date or select End date or enter:");"")enter:");"") -inally
-inally Code:Code:
If([SDPF] Between ([V_PDSD];[V_PD
If([SDPF] Between ([V_PDSD];[V_PDED])) then "Y" ED])) then "Y" Else "N"Else "N"
5.
5. I have this situation!!! +opefully someone can help!I have this situation!!! +opefully someone can help! 3y scope of analysis is set to 4
3y scope of analysis is set to 4 5evel6 5evel6 5evel7 5evel7 5evel8 5evel8
level4 level4
In my report I have 8
In my report I have 8 columnscolumns 6st column 9 level6
6st column 9 level6 7nd column : if
7nd column : if drillfilter(.5evel6/) : 00 then .5evel7/ else if ddrillfilter(.5evel6/) : 00 then .5evel7/ else if d rillfilters(.5evel7) : 00 then .5evel8/rillfilters(.5evel7) : 00 then .5evel8/ else if drillfilters(.5evel8) : 00 then
else if drillfilters(.5evel8) : 00 then .5evel4/.5evel4/ 8 3easure object!
8 3easure object! 3y problem
3y problem I drill on column
I drill on column 6, the second column changes and displays level7 info, 2gain 6, the second column changes and displays level7 info, 2gain drill on col 6 drill on col 6 givesgives level8 info in col7 and so on!!
level8 info in col7 and so on!!
&ut when I drill up then last level info remains while the col6 drills up to 5evel6! &ut when I drill up then last level info remains while the col6 drills up to 5evel6! ;!
;!
Sol:
Sol:
$reate this variable and put it in a blank cell!$reate this variable and put it in a blank cell!:$oncatenation(05evel 0<If(Drill-ilters(.tate/)):00 =hen 6 Else 5ength(Drill-ilters())9 :$oncatenation(05evel 0<If(Drill-ilters(.tate/)):00 =hen 6 Else 5ength(Drill-ilters())9 5ength(#eplace(Drill-ilters()<090<00))>7)
5ength(#eplace(Drill-ilters()<090<00))>7) "hat this does is, this counts the
"hat this does is, this counts the number of 090 (hyphens) in the text number of 090 (hyphens) in the text of the function returned byof the function returned by the drill filters function!
the drill filters function! If the the Drillfilters functions returns blaIf the the Drillfilters functions returns blank, means, you haven%t nk, means, you haven%t drilleddrilled on anything, so the level is 6, and if drillfilter is not blank and no hyphens in the drill filters results on anything, so the level is 6, and if drillfilter is not blank and no hyphens in the drill filters results then the level is 7 and
then the level is 7 and then if the number of hyphens is then if the number of hyphens is 6 then level is 8!6 then level is 8! ?!
?! I have a "I have a "ebi #eebi #eport in &o @i #port in &o @i #8 , which has 8 , which has currencurrent A=D, rt A=D, revious Aevious A=D and B=D and Barianariance !ce ! -or the variance column currently i have a numerical data
-or the variance column currently i have a numerical data , now i got , now i got a new reCuirement for whicha new reCuirement for which i need to give a condition as
i need to give a condition as if Bariance 6
if Bariance 6 99 -avourable99 -avourable
if Bariance F 99 Unfavourable ( ie 9ve values ) if Bariance F 99 Unfavourable ( ie 9ve values ) the variance which are F6 (i!e
the variance which are F6 (i!e Bar:7, 8!!) should be displayed as it is!Bar:7, 8!!) should be displayed as it is! i tried using alerters but didnt work as expected
i tried using alerters but didnt work as expected
olG Either convert numbers to strings using -ormatNumber() function or
olG Either convert numbers to strings using -ormatNumber() function or use an alerter to display in use an alerter to display in aa cell a text instead of a number 9 all that based on a condition
cell a text instead of a number 9 all that based on a condition H!
H! I havI have the the fole followlowing oing objebjects cts in a tain a tablebleGG $ustomer id, -irst name, urname $ustomer id, -irst name, urname =hat are sectioned by tate!
=hat are sectioned by tate!
"hat I am trying to do is to show only the customers with eCual surnames! o if there are sur "hat I am trying to do is to show only the customers with eCual surnames! o if there are sur names with two or more $ustomer Id%s, I want to show them (and only them)!
names with two or more $ustomer Id%s, I want to show them (and only them)! Imagine the following valuesG
Imagine the following valuesG $ID 9 -irst name 9 urname $ID 9 -irst name 9 urname 6 9 John 9 Doe 6 9 John 9 Doe 7 9 &ob 9 3arley 7 9 &ob 9 3arley 8 9 #ita 9 3arley 8 9 #ita 9 3arley 4 9 &ob 9 5ow 4 9 &ob 9 5ow
It should only showG It should only showG 7 9 &ob 9 3arley 7 9 &ob 9 3arley 8 9 #ita 9 3arley 8 9 #ita 9 3arley
I tried to solve this by counting and then filtering, but I can%t get the count right! :count(.sur I tried to solve this by counting and then filtering, but I can%t get the count right! :count(.sur name/) gives 6 for each row!
name/) gives 6 for each row!
Sol:
Sol:
I had to include the section oI had to include the section o bject in the in() function! oGbject in the in() function! oG:($ount(.$ustomer id/) In(.urname/<.tate/)) works fine! =hanksK :($ount(.$ustomer id/) In(.urname/<.tate/)) works fine! =hanksK
9.
=here is a value6 column (varchar7) in table 6 (has numeric values except for a few rows which has some alpha numeric)value7 column (varchar7) in table 7 (has numeric values except for a few rows which has some alpha numeric) 9 oracle database
=he reCuirement is to get the d ifference between the two columns for those that have numeric values and leave as is if the rows have alpha numeric strings!
I used the 0tonumber0 function at report level and was able to get the desired difference between the two columns! &ut for 8 rows, I get LE##'# as the row value! It has numeric data itself! I went to sCl navigator and checked if I can get the difference for those 8 rows and I got it there but here at "E&I I am unable to see it!
eems strange but can anyone help me out in this
I have observed that, if I use 0tonumber0 function, all the rows are being converted to number except for those three rows! I could clearly say that those are numericals and I can even extract the differences between those values in A5 navigator but here it is not happening so!
Sol:
$an you try to use some flag like Istring or IsNumber in your If() like9Code:
=If(IsNumber([Object]); Difference;Else [Object])
Not sure it will work or not, but you can try it!
6! I have a table in one tab and the formula used is 9 Code:
=Sum(If(Match([Sell];"B");-Abs([Amt]);Abs([Amt])) ForEach ([Trade Id];[Account])) In ([Date])
Now when I use the same formula in a standalone cell, it is giving me L3U5=IB2UE Error!!! $ould someone please guide me what could be the issue and how to resolve it !!!M
Sol:
lease create a measure value instead of creating the seperate calculation for each tab! 2lso ensure the objects (2mt, =rade Id, 2ccount, Data) are availble properly!11.
I have a reCuirement! 'ne of the objects is returning the values in +ours! -or exG the value is 6!;? hrs! I have to split this value in to daysGhoursGmin!i!e 8DaysG6+rsG43in
6!;? O; : PP 3in 99 if we covert this, we will get 8DaysG6+rsG43in!
I am finding it difficult to incorporate the logic to get this! lQ help me with this logic! &asically, I have to convert the total number of minutes in daysGhoursGmins!
Sol:
=ry this9Code:
=Truncate(([NumberObject]/24);0)+" Days : "+Truncate(([NumberObject] -(Truncate(([NumberObject]/24);0)*24));0)+" Hours :
"+Truncate(((((60/100)*(([NumberObject] - (Truncate(([NumberObject]/24);0)*24))-Truncate(([NumberObject] - ((Truncate(([NumberObject]/24);0)*24))-Truncate(([NumberObject]/24);0)*24));0))))*100);0)+" Mins "
12.
I have ?7 rows in for each section in my report, l ike wise i have 7 sections! +ow can i keep all ?7 rows in same pageM13.
I am using the "eb Intelligence on @I #7!"hen I duplicate a Cuery and change the universe on the target one, the source Cuery universe also changes! I am trying to duplicate the Cuery to keep the o bjects but would like to h ave a different universe on the source and the target Cuery!
Is that possible at all or does the duplicate Cuery also systematically duplicates the universe in both the source and target CueriesM
Sol:
If you are duplicating and changing the universe, it will get changed for all universes, better you try to 2dd New data provider for your new Cuery! 2nd see if it is working or not!14.
I am creating a "E&I report where i am taking a count(.clmnbr/) and populating it into a cell! &ut whenthe count is greater than i am getting the count d isplayed but when the count is eCual to it is not getting populated in the report! I tried the to format number option and changed the option to 0Number0 but still it is not working!!!Sol:
=ry if(isnull(count(.clmnbr/) )<<count(.clmnbr/)15.
Is there a way I can schedule a webi report, exG that runs every hour from 6723 to H3,everyday! 'ur reCuirement is that the report has to run 673 9 H3 on Day96 R 673 9 H3 on Day97 and it goes on!
Sol:
1ou could try creating an object in your Universe that f ails at certain times of the dayM If $urrent=ime between pm and 66am then 3yNumber S else 3yNumber!Include that in your report! =he divide by Qero error will cause your report to fail, and because it fails it won%t be sent out!
=he just schedule the repor t to run every hour!
ersonally I%d just create H schedules! +ave then run every day! 'ne at 67, one at 6 etc! 3uch easier!
16.
I want to display customiQed +eaders!Dimension Balues are 6, 7, 8, 4! &ut the user wants the column header to be displayed at =6, =7, =8 R =4! I tried to change the background color and overlay a text box! &ut when i export it to Excel, it doesnt display them!
Sol:
$oncatenate = with the object and use this newly created dimension in crosstab!17.
I have a dimension object which has multip le values per customer!I would like to display all the values at once in one cell instead of displaying a row for each! I have been looking into using the revious function but it needs the context so doesn%t work for me! I have &' @I #7 so d on%t have the #elativeBalue function!
Sol:
I fixed this one by using the A5 mode "ebI! I used the wmconcat oracle function against the dimension i needed to aggregated and then created a set of variables at the report level to display it properly!18.
+ello, i am getting the error listed below when trying to add objects to an exisisting report! "e are using 5inked universes! I understand this could be caused by linking universes but what should i check for to resolve this errorM what are the steps! =hanks in advance!Universe not found! ee your &usiness 'bjects administrator! (ErrorG "I P6)
Sol:
=hat error usually results from not having access to the universe! =ry creating a new "ebi report and see if the universe shows up in the list of universes available to you!19.
"e have some #eport templates developed by a user! ince we are re9using these templates for report development, in all the reports %2uthor ($reated &y)% is coming as the user who has created the template! Is it possible to change this name by 2dminSol:
1ou need to use the sdk for this !!!'# you can try to delete the authorK &U= take care about his personalSinbox documents 7! I am using &' 8!6 with 'racle!!
I have data like this!! Code: 01 02 03 04 (month) a 85 65 45 85 b 200 400 500 600 c 45 25 65 20 d 300 500 700 900
=his is crosstab report! I have to make a line chart!! but the values for & and D are high! +ow can i divide the values for only row & and D! is it possible or is there any workaround for it!!
olG 1ou mean you wish to implicitly make the values smallerM =ryG
Code:
=If [Dimension]InList("a";"b") Then[Metric]/10 Else [Metric]
21.
I%m trying to use User#eponce in report header (InfoBiew)! 3y need is to disp lay text depending on user%s choice! If user%s choice is %1es% then text6 is displayed, else text7 is displayed! "hat is correct syntax for doing thatM Tive me please some example!olG 2ssuming the text of the prompt is 0lease enter 1es or No0, you would use the followingG :If(User#esponse(0lease enter 1es or No0):01es0<0=ext60<0=ext70)
Code:
=(If([the_question])="Yes" Then "text1" Else "text2")
22.
Is there a way of scheduling repo rts using "ebi rich client! I just got it in my computer and don%t know how to do it!olG cheduling is possible only in $ 3$ and Infoview!
23.
+i guys, would like to know whether does the format painter on the "ebi able to copy another fieldScell %s number format!ExampleG
$ell6 is a $urrency format! $ell7 is a default format!
I use format painter to copy $ell6 to $ell7, it only changes the colour and font, but not the default 9 $urrency!
Is this a limitation of "ebiM 2m I able to change the settings some whereM
olG 1ou cannot paint number f ormats! 1ou can, however, select multiple cells at once and set a format to all of them!
24.
I am having bar chart in a webi report! I have a prompts for the start data and end date for the report! "hen i select some data and if no data is prsent for it then the chart also doesn%t show up!I NEED axes and legends to be displayed so that that space will not be blank so that user can understand there is no data for the particular bar chartSmonth!olG $heck to see that the 0show w hen empty0 box is checked! 2lso you can consider a union Cuery that brings back at least one (Qero) row so that some data will appear!
25.
$urrently I have to mannually configure infoview preferences one by one , and the total number of users might be several hundred! Is it possible to $onfigure infoview preferences for hundreds of users at one timeM 2nybody could give me tips about how to handle this easilyMolG In $3$, In manage, go to applications! 'ne of the application listed will be Infoview! Trant rights from here to user groups!!
26.
I am a &' #eport developer but i dont know know what type of data does 2udit tables will holds! +ere my users are asking me can you give some detial informaiton and couple of reports on audit tables!!! but i dont know how can design univers ( means tables and all), type of data does it holds and what type of reports can i build!how and where can i find audit tables and what connection can i use
olG If you want to be able to see the Auditor folders and reports, BO Admin should give you access to the following
6! Adm-Auditor folder in Publi !olders 7! Ati"it# Universe
8! Auditing Connetion, that is the &' or Designer connection used by Ati"it# Universe
27.
I have searched the forums and can%t find it!!!!does anyone know how to get the last working day of the current month at report level with a variableMMolG $reate following variables Code:
Currentdate = currentdate()
Code:
Last Day of Month = LastDayofMonth([Currentdate])
Code:
Last DayName of Month =Dayname(LastDayofMonth())
-inally create a variable as Code:
Last Working Day of Month = If([Last DayName of Month]="Sunday") Then
Relativedate(LastDayofMonth();-2) Elseif([Last DayName of Month]="Saturday") Then Relativedate(LastDayofMonth();-1) Else LastDayofMonth()
+ope that makes sense and helps!
28. I have a situation where I want to isolate only those rows of data which have a 3IN date< for exampleG
3atter No! 3atter Name Date Indiv! Name 4 Johnson 6S7S66 Jackson
4 Johnson 8S67S66 5ee 4 Johnson 4S7S66 Jackson
I wish to apply a variable which will only show me the row with the date 6S7S66! +owever, when I use the variable found here, I getG
3atter No! 3atter Name Date Indiv! Name 4 Johnson 3ultivalue Jackson
4 Johnson 3ultivalue 5ee
3y variable isG .Date/ "here (.Date/:.3in Date/) In (.3atter No!/)
Any Idea..?
Sol:
$reate these 7 variablesCode:
MinDate =Min([Date]) In Block
Flag = If([Date]=[MinDate]) Then 1 Else 0
2fter creating these 7 variables, add the 3inDate as a column to the table and then add report filter S$o%&'ide filter pane which is on the top left, next to !( icon and )ariable Editor icon and put a filter on !lag as !lag*+!
29.
I have a concatenated field of year > attribute (e!g! 7H 2, 7 &, 76 2, 76 & etc)! =he concatenated field has been custom sorted, that means we have a particular order! =he field goes as a header in a cross9tab, which may shrink or expand according to prompt selected! I need to show the last column header of the cross tab in a free9standing cell!=ried a few things unsuccessfully! 2ny ideas folksM
Sol:
$reate a variable for the free standing cellCode:
=Last([Year+Attribute])
30.
I tryed with landscape and 2 siQe, I can accomidate only 4 columns in a report in single page, If i want create more than P columns in single page how can i do thisMSol:
In a "ebi report you can have 7P; columns in a table, but the number of columns being printed in a page will depend on the width R orientation of papers you use!6! I think the largest paper is 5egal, so try to use 5egal in aper R 5andscape as the age 'rientation! 7! =ry to decrease the column widths to fit as many columns as possible!
8! In the roperties of the age, go to age 5ayout and decrease the 5eft 3arg in and #ight 3argin to make some more space to fit in more columns!
31.
Is it possible to use the Data =racking feature to show the actual numeric change in value rather than using the color coded referenceM-or exampleG #eference data : 6 #efreshed data : P
Data tracking would show >4
olG =ry to create a formula using Ref)alue, function! omething like Code:
=RefValue([Measure])-[Mreasure]
32. I do have =able contains =heree column Countr#. Produt and Prod Categor# objects! I do have $hart below the =able contains Coutr# and /o0Of Produts Sold!
Now what I want is when ever I click on $ountry name in the =able then $hart should should show respective country data!! I heard that this is possible by using INU= $'N=#'5 opt ion in "ebi!! $an any one help me how to do it !!!!!
Sol:
Its not possible to change the $har t depending on you selecting a $ ountry in the =able! &ut a work around is, create an input control on $ountry with a Drop Down list or $heck box and then while defining the Dependencies, select both blocks =able and $hart!=o create an Input controlG In the =abs to your left where you have tabs for Data, roperties,
=emplates, 3aps, you%ll see a tab for Input $ontrol! $lick on New and select $ountry and check =able and $hart as dependencies and $lick '*!
33.
$an someone please suggest as how we remove duplicates in a webi reportM I don%t want to use breaks to remove them! Is there any other way to remove duplicates in the reportMSol:
Cuery level GIn the edit Cuery mode!!you have Cuery properties on your right !!under data u have an option that says remove duplicate rows!!#eport level G If u say in a report you can do it by going to properties tab under which you have display tab in which we have an option that says avoid dupl icate rows check it!!
34.
3y webi report displays data across months(in columns) based on region in horiQontal table format! and table is given a title which should be exactly at the center as per table%s width! Now my problem is table%s wid th changes dynamically since all regions doesnt have all months data and only the columns having data should be shown!Now when table%s width changes dynamically, how to align the title exactly at center!!!MI tried working with relative position! but with it only top and left margin will be fixed!!I want to fix right margin as well!! lease guide me regarding dis!!
Sol:
Insert another row above the column names and merge all the columns of that row and type the table name in that merged column!change the background colour and remove the borders and do the formatting stuff if needed!
35.
I am using &' 8!6 sp7! "e have a vertical table with appox 7 columns! ome of the table header cells are merged (in the report header)! 2lso, there are P9; breaks applied on the table! +owever the beakheader are disabled!'nly the table header is displayed on the report!=he issue is that when we drag a column (say F'&JE$=) to the report we don%t get the column header as Name'f(F'&JE$=)! =he column header is blank for the newly dragged column!
lease refer to the attached screenshot! $'5U3N6 and $' 5U3N7 are newly dragged to the report! $olumn +eader cells for DE= and $2=ET'#1 are merged!
=his is a showstopper for us as blank column header doesn%t make any sense for ad9hoc users! $ould anybody suggest on thisM
Sol:
1ou can merge the colum it same data type and asem colum is thier ! same time it gives error Lerror,Lmultivalues on the time u can put second colum is detail objects it will slove ! u candoubleclick the colum and write colum name
36.
I need to create a report about customer data and then section it by age groups! -or example F6 years, 697 years, 798 years, etcbefore i can group itM I also want the age to be dynamic, in the sense that if someone is born on 4th 2ugust 66, today he is 6 years so he falls in group 697, but tomorrow he will be 7, so he will fit into the next group 798!!!
Sol:
2ge:-loor(Days&etween(.&irthDate/<$urrentDate())S8;P) will give you the dynamic age in yearsthen create another variable using If =hen Else logic to group e!g! If(.2ge/F:P<09P0<if(.2ge/:7<07>0!!etc)
37.
"e have build one report which has three different blocks inside one section and each block holds column called commision and this column hold different calculation for all three &locks!what i need is the um of all three $ommision which holds different calculations hould be displayed as grand total at end of report! $an any one guide me how to do this M
Sol:
Declare each of them as local variables say a, b, c! um those variables!! a>b>c! 3ake sure a, b and c are measures!38.
I have a report has belowG ID name rev gaps67P4 222 P7 8 P4?H &&& 4H7 6
and detail report tab which show who are the cust that has gaps for particular ID as belowG ID name rev gaps cust custname
67P4 222 P7 7 64PH? $$$ 67P4 222 P7 6 7P4?H DDD
so in the above report ID 67P4 has 7 gap s with same cust and custname!so i doesn%t want to show that as aggregrated!Ineed them as individual rows as belowG
ID name rev gaps cust custname 67P4 222 P7 6 64PH? $$$ 67P4 222 P7 6 64PH? $$$ 67P4 222 P7 6 7P4?H DDD
so i selected the avoid duplicate row aggregation option but its not working!it%s displaying as aggregated row!Is there any solution to f ix it up!2ny help is appreciated!
Sol:
In the 1uer# Panel, go to the Properties tab, there is an option with checkbox to Retrie"e Dupliate Ro%s!'r
In the report, select the table and go to Properties tab 9Displa# 9A"oid Dupliate Ro% aggregation !!!$heck that option!
39.
I have created a variable by using if statement like below!:If((IsNull(.'rd 'rder/)2nd IsNull(.#ec 'rder/)2nd IsNull(.Ipv 'rder/))<020)
it is working perfect! In the same variable i need to ad d other conditions as like same i tr ied like below to add one more condition but its giving error
:If((IsNull(.'rd 'rder/)2nd IsNull(.#ec 'rder/)2nd IsNull(.Ipv 'rder/))<020) 'r If((IsNull(.'rd 'rder/)2nd IsNull(.#ec 'rder/)2nd IsNull(.ap 'rder/))<0IB0)
Sol:
=ry thisCode:=If(IsNull([Ord Order]) And IsNull([Rec Order]) And IsNull([Ipv Order])) Then "PAP" Elseif(IsNull([Ord Order]) And IsNull([Rec Order]) And IsNull([Pap Order])) Then "IPV" Else ""
40.
+ow to use NotNull function for example i want the condition like:(If pap amt not null then 02 and if I pv amt not null then 0IB0 and #ec amn not null then 0matche #ec and diff amt :Diffamt)! how to achieve this condition Diffamt is my another variable
Sol:
2s there is no NotNull, you need to use /otR Is/ull together as /ot,Is/ull,2Ob3et4!Code:
=If(Not(IsNull(pap amt))) Then "APP" ....
41.
2n object ($'=) is defined as varchar in the database of $U##EN= table! 2nother object ($'=) is defined as varchar in the database in #EBI'U table! Now the reCuirement is to get thedifference between the two values for a given set of dates!
I have observed that the column values in $'= have some characters concatenated after the number (for a few rows)! If I generate the A5 to pull the $'= column from any of the table, it is generating the result in the A5 Navigator!
I defined the $'= object as measure using 0tonumber0 and tried to use it in "ebI! I get the error msgG
02 database error occured! =he database error text isG '#296?77G invalid number ! ("I 66) =hen I tried using =#I3 on the object to remove the alphanumeric characters (not sure if th is is a good idea) following the number and tried to use it on the report! I get this error
02 database error occured! =he database error text isG '#2964H6G invalid number format model ! ("I 66)0
Sol:
Use some below kind of formula and surely it will help you as this is working fine for me!#E52$E(=#2N52=E(colname,%abcdefghijklmnopCrstuvwxyQ2&$DE-T+IJ*53N'A#=UB"@1V%,%%), %%,%%) in place of colname put your desired column name!
42.
I am returning client names which must be ranked by the count of -irst names only! I created measure to count the name and a ranking that gives me the top 7P based on a substring of the first ; characters!+owever, I need to show the entire first name, regardless o f lenght, (but only the first name! Names are entered in D& as -irst, 5ast) and I%m not sure how to accomplish this!
ExampleG 3ason works fine with my setup, but 2nthony is returned as 02nthon0! If I add a ?th character the 3ason shows 03ason +0
Sol:
Use the os() to dynamically determine the starting postion of the substring =ry thisCode:
=Substr([Name];1;Pos([Name];" ")-1)
43.
"e have scenario where we are need to pull out a sum value of column in tab6 and the same value to be shown on the =ab7!is there are any option like a referring a we do it in Excel or any other options in $ontext!
NoteG "e did a analysis the with variable method, we are arriving as a w rong result as the formula on the variable makes the result set to gi ve the value from the data elements present on the =ab7 and it does not take the data values present on the =ab6 and +ence 2rriving on wrong result! 2bove method does not work on!
Sol:
1ou have to use the hyperlink method to pass the value from =ab 6 to =ab 7! 2lso you can try to create a variable with the help of context operators to bring the result of =ab 6 in =ab 7!I have tried the following it seems to be workingG $reated a Bariable asG
Code:
Test = FormatNumber(Sum(Measure);"##")
=hen, use this variable in =ab 7!
44.
In webi xir8, i have a four tables in the report, when i use rowindex funtion in table 7, it will start the index no! from table 6 end no!why is not starting from the Qero for table 7! any idea!
Sol:
In normal condition rowindex() d oesn%t work the way you are expl aining because we have used it several times before and works the way you want!&ut there may be some additional conditions in your report like filter or any thing similar which may be ruining the show!
I would suggest you to make the same report from scratch in the next tab and then apply condition one by one then probably you will find the culprit!
45. I need the first day as in mmSddSyyyy format! my .month names/ has
3ay June July 2ugust etc
olG 2ssuming your dimension is a string, then
:-ormatDate(=oDate(.month name/<03mm0)<0mmSdd0)>0S7660 will convert your month to a date, but the year is hard9coded
4;! #unning into a wierd situation trying to chedule a "ebi report to a csv format file that gets emailed as an attachment! =he report filters are being ignored in the schduled instance! $an anybody confirm this behaviourM
olG $B always gives you what the Cuery returns 9 if you have report filters, you won%t see them in $B! Excel, yes! If you need that in $B, tweak your A5 to limit the same way!!!
4?! I am working on this report where the Dims9 hysician, #ate, =arget, 2verage!
=here is a section on hysician and I wanna include the #ate (i!e the performance of the physician based upon a set of *Is(metrics)!
#ate: numeratorSdenominator
=arget is the number set for each *I!
2verage is the figure of the (total numeratorStotal denominator) so that each physician knows hows heSshe is doing amongst hisSher peers!
I am unable to include an average variable since there being a section on hysician it is showing me the same value as the #ate!
olG =ry applying context operators, in your case you can use In Break ! 4H! I am using &o 8!6 sp8 with 'racle!! I have a table say!!
Code:
=============================== Ga Atlanta Bus 45 43 Ga Atlanta Map 42 13 Ga Atlanta Water 65 22 Ga Atlanta Bill 55 25 ================================
ales is a measure column with None as projection in universe! I what to show to p service name along with price based on max(sales), so i made a variable in report
maxsales : max(sales) to get top service name topservice : ervice IN (maxsales)
but it is giving me Lmultivalue error!! $ould you please let me know where i am going wrong!!! olG =ry this codeG
Code:
topservice = [Service] Where( [Sales]=[maxsales])
4! +ere I have to create a "ebIntelligence #eport and have to filter on date (current date minus 7 weeks)! Is it possible to create the filter in EDI= AUE#1 level or have to create a variable in the report level! =hanks in 2dvance for your valuable suggestions!
olG It is not possible to do it in the Cuery panel unless you write a custom sCl! o you can create the filter in the universe or in the reportG
UniverseG -ilterG Welect(DatesXdate'bj)Welect(DatesXdate'bj)96P #eportG BariableG :If(.date'bj/currentDate()96P) =hen .date'bj/ P! lease check how can I correct the formula belowG
:If(.$ompleted Day/!.Date=ime/.Due Day/!.Date=ime/,0-ailed0,0assed0))
=his prompt appeared 0UnrecogniQed input %,% at position P6! ("I 66H)0 whenever I tried to enter it!
olG =ry semicolons instead of commas! Code:
=If([Completed Day].[DateTime]>[Due Day].[DateTime];"Failed";"Passed")
P6! I have a report in which there are around 6 tables and I am exporting that report in excel which is working fine!
Now as $B bypasses all report calculation, we take the output in Excel and then ave 2s it !$B, after doing this , we are getting many extra columns in the report as I guess all tables follow the format of first table which is there in the report! Is there any solution to resolve this issueM olG 2ctually the width was different in all tables, that%s why the issue was there!!! I made the common width for all cells and tables placed in the report and now it is working fine!
P7! I have a scenario something like ID ID amt6 amt7 diff 6 6 6 6
7 7 7 8 96
there is a scenario where ID%s are not available and i need to show the amounts using another table as a reference! =o be specific i need to show the user that the amount difference is from a different table and not from ! +ow can i show the repo rt in "ebIM $an i work around something in designerM
P8! 2nyone has any insights on filtering records based on two data providersM D6 has P records and D7 has 6! =he are merged based on an N column! I am only interested in the P records that exist in both Ds! +owever, "E&I seem to always perform calculations based on the 6 records! =his is incorrect because my section totals are summed based on the 6 records instead of the desirable P records! +ow can I filter out the other useless P records in the reportM
olG =ake the key field which makes P records fro m D6 and as suggested if there is any Null logic , you can apply that at the edit Cuery level!
P4! I am taking later of month dates and I am suming up the months for their total premium! I want to cut the month of 3ay off midway, so I only want 3ay to go to the 6?th and sum up the
premiums to that date! Does anyone know how to do thisM
olG 1ou have day in your universeM If yes, you can select the value between 6 an 6? of may in one variable! 2nd then sum this variable with other months!
PP! User has to print some documents from a webi report! so instead of opening each report in pdf and printing them individually can a single pdf be generated so that user can print that pdf directlyMM
olG In Info)ie% go to Preferenes 95eb Intelligene 9Selet a default "ie% format 9 select PD! 9 click O6 in the corner far down right!
Now the users wont have to save the Doument as PD! to print! =hey can just open the Doument in Info)ie% 9Rig$t li7 and select Print!
&ut make sure, in the documents(all the reports in a document) the Page Si8e and Page Orientation is set!
P;! I need to display the values in different column e!g column6 Name OOOOO Nancy David am richard deepak Expected output
column6 column7 column8 Name name name
Nancy am Deepak David #ichard
+ow can i implement this logic at report level
olG "hy dont you turn the table to a 9ori8ontal tableM Rig$t Cli7 on table 9 urn to 99ori8ontal able!
=hat is the best way to do it, unless you want to create as many number of variables as the number of values you have in that column
P?! we are using &'@I #7, "ebI! "e have a measure in one column, it is sorted in Desc order, highest value on the top, what I am trying do is lets say 26 is my top row, next one is 27 !!and so on!! I need to fill another column (&n) with this kind of value (2nS26)!!so that I know the relative
postion of that customer with the top one!!! I hope you understood my logic !! 26 9 7 &6:26S26
27 9H &7:27S26 28 9? &8:28S26 24 9P &4:24S26
olG same logic applies, syntax is dif ferent :.value/S(3ax(.value/) In &lock)
if you want to display as a fraction use :.value/R0S0R3ax(.value/) In &lock
PH! I have a report that I have put a section on my 2ccount field! "hen I run the report there may be PY of the accounts that have had no update that day so I have unticked %show when empty% o I can see that this only hides the sections as described, which means my populated sections are scattered and may only be published on the latter pages!
o is there a setting that brings forward all of the populated sections so it prioritises them and leaves the hidden sections at the end of the reportM
olG $reate a variable like that checks if there is data for a particular 2ccountNumber as per yesterday or last transaction date!
Code:
Flag=If(IsNull([Measure]) In [Last Date]) Then 0 Else 1
2dd this column to the table in the ection! 2nd sort the sections depending o n this column! 2nd hide the column by changing the background color of column, text of the column and borderlines of
columns as the background of the page so that it would be completely invisible!
P! I have reimaged my system and lost all my docs that were created through web intelligence rich client! Is there a way to retri ve them , can you please help me!
olG If you exported them to InfoBiew, they should still be there! 'therwise, unless you did a backup you are probably out of luck!
;! I want to show a line chart!! with legends!! I searched and could not find from where to enable the legends on line chart!! Is it possible to have legends on line chart!
olG elect the C$art and go to Properties tab 9 on expanding Appearane 9 in Legends 9 check the box!
;6! In my report I have title like Code:
="Title1 Periods "+[Start Month]+" to "+[End Month]
+ere objects tart 3onth and End 3onth are objects in the universe!
=he problem I am facing is that when I am trying to purge the data then it removes the title also and when I am refresh the report it comes with start and end month!
$ould any one help me o n this issue as I want the hard coded test as it is! olG ;ou %ant t$e title to remain. am I rig$t<
=o achieve that, you need to change your =itle formula, remove the 2Start =ont$4 and 2End
=ont$4, instead create variables with Userresponse funtions to capture the 2Start =ont$4 and 2End =ont$4
Usr_StartMonth = UserResponse("Enter Start Month:") Usr_EndMonth = UserResponse("Enter End Month:")
=he =itle should be Code:
="Title Periods "+[Usr_Start Month]+" to "+[Usr_End Month]
,"ariables in t$e formula instead of t$e ob3ets fr om t$e Uni"erse 2nd now the =itle wouldn%t disappear even if you purge the report!
;7! 2s we know we can save "eb #ich client to our local machine! +ow to save the rich client and whats the file extentionM
olG #ich $lient reports are normally saved to the Userdocs folder within 3y DocumentsX3y &usiness'bjects Documents as a !wid
;8! Is it possible to create a hyperlink on a report tab that links to a different report tab within the same documentM Not passing parameters, just a simple link! I know how to do the 'penDoc links to other documents! I am trying to create a link from one report tab to another report tab within the same document! *ind of like having a table of contents page with links to the different tabs in the report! Is there a way to do thatM
olG 1ou can link a report to another report using a hyperlink which uses a open doc functionality! 6!#ight9click #eport 7! $lick roperties! 2 w indow displays the document information
7!3ake a note of the ID of the document! =his ID is used to refer to #eport 7 while creating 'penDocument statement for linking #eport 6 to #eport 7!
8!'pen #eport 6 in Edit #eport mode! 4! #ight9click the cells of the lant $olumn!
P! $lick +yperlinks New +yperlink! 2 new window appears! ;! =ype the following statement in the new window!
httpGSSFservernameGportS'penDocumentSopendocSopenDocument!jspM iDocID:!!!!Rs=ype:widRs#efresh:1Rs"indow:ame
?! $lick the arse button! In this example, IDocID: !!!! (ID of #eport 7), s=ype : wid (as target document is in "eb intelligence document format)!
2dd a parameter to the opendoc link, sReport/ame*>ab /ame #ou %ant to open? !
;4! I am trying to compare the days between two dates and if that value is greater than 4P to return the sum of an order Cuantity to my table for the specific ales erson! I have the following formula built but I am receiving 0LL3ultivalue0!
:If(Days&etween(.5arge hip "indow/!.#eCuest hip Date/<.5arge hip "indow/!.-uture $ancel Date/) 4P< (um(.5arge hip "indow/!.&ackordered Auantity/)))
'rder Aty
ales erson 6 LLmultivalue ales erson 7 LLmulivalue ales erson 8 LLmultivalue olG
Code:
=Sum(If(DaysBetween([Large Ship Window].[Request Ship Date];[Large Ship Window]. [Future Cancel Date])> 45; [Large Ship Window].[Backordered Quantity]))
;P! I%m on &'@I #7 7!!!and planning to upgrade to @I 8!6 or &I 4!!
Is there any &' trick that would allow the parameter values selected by users to be included with the $B export of "E&I rp tsM I know $B is just the raw data from the A5 Cuery itself! &ut just wanted to see if anyone found a trick for doing this!
olG I would suggest to create a cell in the report with Userresponse function in it!
;;! I wanted to check if there is any limitation that we can set in $3 as how many pages the Cuery should return at max! &ecause, the A5 generated by &' report, when run in A5 Navigator returns more, say 6, rows, but in the report it is returning only P rows (6 rows per page 9 total of P pages)! Is there any kind of setting that I need to change, or I am doing a missing something! I also wanted to add that, for a given ID some of the rows returned are not matching to that run at the D& level! I am using a sub9Cuery in the where clause of the "E&I report!
olG 2sk your Universe Designer to look at the universe properties and remove the default limit of P rows!
;?! I have a report that has checkbox Input $ontrols! when the user is viewing the report and try to manuplate the input controls its throwing an error saying cannot apply filter to the report elementG D!D'6eP! I tried to do the same with my admin account still its showing the same error but when when I edit the report its not throwing the error! =he problem is with the Biew mode olG =ry to change the Info)ie% Preferenes to view a report to Interati"e mode! To to
Preferenes 95eb Intelligene 9Selet default "ie% mode 9Interati"e! 2nd also!!!!Is the user trying to add or edit input controls in an instance of a reportM
;H! I have a report showing data for ; Cuarters(Atr formatG766 A6)! I have to display data for max Cuarter for some tabs! I am able to create and filter report for 3ax Cuarter but when i did that the 3easure values become Qero!
olG Use 3ax function to get 3ax Auarter! =hen i applied Auarter : 3ax Cuarter
;! +ad this reCuirement of saving a report in !xls format on &' server (not on local machine)! Is it possible via scheduling the reportM $an it be event based schedulingM $an someone p lease guide as i%m very new to scheduling reports!
olG 1ou can do it by scheduling the report! In the S$edule options, in the !ormats and
Destinations, change the Output format to =irosoft E(el, in the Output format details, check !ile Loation, click on Destinations and Settings 9 Uncheck Use t$e @ob Ser"ers defaults, specify Directory as ! ,a single dot, select a !ile name or select Speifi name and enter a report name and add e(tension, Enter the UserID and Pass%ord of the "indows user having R&5 pri"ileges on t$e Ser"er ma$ine and schedule the report!
?! I have a report when i run in Deski it runs within seconds!=he same report when i try to open in "eb I and click refresh to enter the propmts it takes for ever to show me the promt window to enter the parameters!Does anyone have an idea about the root cause of the issue!Is it something to do with "eb I server performance or with the report itself!=he promts are simply dates(start and end) creted in the report! 2ny ideas and input on this would be helpfull!
olG It might be because of the J#E version! lease check if it is the right one for your "eb9I version! ?6! I have one reCuirement where in i need to get previous days data, if no data present for the
dont get any result! -or Example!!
unday%s no 5oad happens in the 'D and no data would be present! I would need to display sat data! monday9 6 tuesday97 wednesday98 thursday94 friday9P satuarday9;
sunday9 No data loaded! +ence i need to display sat data as ;!
=
his needs to be done in "E&I @I#8olG elect data for the last se"en da#s (this you can play with based on the max number of consecutive holidays )! =hen within "ebi filter your report so that only data related to max(date) is displayed!
?7! I need a formula something like this, If the condition is true then 3onth should display all values specified inlist after 3onthly,
:If(.=o3onth 'f End Date/ In5ist(;<?<H<)) =hen (.3onthly/ In5ist(0July0<02ugust0<0eptember0)) olG 1ou can try like this
:If(.3onth/: ;<%June%<(else if (.3onth/: ?<%July%<(else if (.3onth/: H<%2ugust%<(else if (.3onth/: <%eptember%))) upto december!
&ut here im not hearing clearly is %2re using =ont$ as rompt% , if not above syntax may work! ?8! I%m building a massive nested if variable and I have got to a part where i must say
if((x:0matched0 and y:0E0 and Q is null)<03=rade0< if(etc etc
I%m having a bit of brain failure here but I only seem to have the use of operators N'= and NoNull! "hat is the easiest way to use these or any other operators for that fact to express in "ebI termsG 2ND Q I NU55
olG =ry it like this, Code:
if((x="matched" and y="E" and Isnull(Z));"MTrade"; if(etc etc
Isnull,, and if you want /ot/ull,, then it should be /ot,Is/ull,! +ope you got the point! ?4! $an any one tell me how can I set the "ebI report to fit to 24 pdf siQeM
$urrently in my report out of 67 only ; columns are corrently displayed!
Do we have set to page width feature available in "ebI which was available in DeskIM 'r you can provide me the any other solution also!
olG $lick on the blank area in the report, go to Properties tab 9Page Orientation 9Landsape! "hatever number of columns you get now, that is i t! Do you have a chance to use Legal or Letter paper, those are bigger than A and you can get many columns!
?P! Is it possible to somehow capture a value in a table in a "E&I report and paste it soemwhere else in the reportM
olG$reate a Bariable using all the conditions to get that value and then insert the same formula where ever you want! It has limitations though!
ExG =o get ales #evenue of $alifornia of year 7P from table with 1ear, tate R ales #evenue columns!
Code:
Variable = [Sales Revenue] Where ([State]="California" And [Year]="2005")
Now use this formula in an empty cell or wherever you want to display!
?;! I have the following formula in the "ebI rich client to get a converted date valueG :=oDate((.=rade Date/>.=ime =rade/)<0yyyyS33Sdd hhGmm ss0)
=he fomual parses without an erro r! 2 sample of the data is .=rade Date/ string : 766P8
.=ime =rade/ string : 67684P
o .=rade Date/>.=ime =rade/ string : 766P867684 P "hen inserting the column into the table I%m getting LE##'# I don%t know why "ebI is not capable of more verbose logging!
olG 1our format string needs to match the concatenated value! i!e! 0yyyy33ddhhmmss0 ??! I have a dimension .enddate/ of format mmSddSyy now i want to convert it into 333911
i!e ?S7PS66 should d isplay as JU5966 and i get the Cuarter also as A6! (my business starts from JU51)! +ow can i do this at report levelM
olG Use the Auarter() function
e!g! :Auarter(.enddate/) will return 6,7,8, or 4!
N& =he Cuarter is a calendar year C uarter< if you want a f inancial year Cuarter use :If(Auarter(.enddate/):6<4<Auarter(.enddate/)96))
?H! I have two table in A5 erver!
6! 3ain-orecast !!!!!!!!!$olumnG alesBalue (current B>2pplied -orecast) 7! -orecast 2pplied!!!!!$olumnG 2pplied-orecast (only the current applied)
I need to divide current month 0sum(alesBalue)0 by last month sum(2pplied-orecast)! -or e!g! -96 : .alesBalue(of 2pril)/S.2pplied-orecast(of 3arch)/
-98 : .alesBalue(of 2pril)/S.2pplied-orecast(of Januaray)/ =here will be a prompt to enter 3onth!
lease guide how to achieve this task in "ebi! olG 1ou will need to create several variables
-in d End ($urrent 3onth) :=oNumber(User#esponse(0Enter -inancial eriod(End)G0)) rev 3onth :=oNumber(User#esponse(0Enter -inancial eriod(End)G0))96
ales5ast :.alesBalue/ "here( .-inancial eriod/ : .-indEnd/)
-orecastrevious :.2pplied-orecast/ "here( .-inancial eriod/ : .rev3onth/) -96: .ales5ast/ X .-orecastrevious/
=he calculations are based on the prompt, so as the prompt value changes, the results will change! ?! I am using &' @I #8 p7 and below is my issue in webi! I have reCuirement to display just one
row when the count is same with any description! as below!
+ere the first column has -oo repeating th ree times and the count is same for all rows i!e ;! o I just need to display one row with any description!
current 'utput 999999999999999
-oo ; ayment -oo ; ource -oo ; $ard &ar ? Tateway Desired 'utput 99999999999999
Name $ount Description
-oo ; ayment or ource or $ard 99999 (display any one )
&ar ? Tateway! $an anyone please help me acheive this than using previous function! olG $reate a variable something like<
Code:
=If [Discription] = "Payment" or [Discription]= "Card" Then "Source" Else [Discription]
=hen use this variable instead of your Discription object! 1ou might have to convert you $ount object to a dimension variable if it is currently a measure aggreate object!
H! $an someone please give me the code where i can hide error results on the formula! 5ike if i get a result that will give me LDIBS, the output on the report will be 00 instead of getting the error 0LDIBS0! =hanks!!
olG Use IsError() function! e!g! Code:
If(IsError(A/B);0;A/B)
or
Code:
If(B<>0;A/B;0)
H6! 'ne of the user told the excel export is failing and when I try on my side it%s very very long!
696P minutes to refresh doc (D& extraction '*)! &ut then the export as Excel is taking more than 7 minutes and finally the document are not so big G
O Excel file G 73o O "ID file G ?3o
"hy is the convert option so long and what can I do M
olG Is the ave to Excel giving you an errorM 2nd the file is not being saved to excelM "ith an error, maximum siQe reached or somethingM
5og on to C=C 9Ser"ers 95eb Intelligene Proessing Ser"er 9Properties 9Binar# Stream Si8e will be set to mb, increase it to +mb or more!
1ou%ll be able to save lengthy reports to Excel or D- now!
H7! Is it possible to create custom sections! I want to create sections of data within a certain range! ExampleG duration value !P 6 !? H ! 6?P 6!P 8 6! 7;
between and F6 between :6 and F P
Is this possible in the report or must this be done in the universe! olG $reate a variable for ex #ange here!
=he formula for the variable will be
#ange:If .Duration/ and .Duration/F6 =hen 0between and F6 0 ElseIf .Duration/:6 and .Duration/FP=hen 0between :6 and F P 0 Else 0greater than P0
=hen put the section on this variable hope your problem will be resolved!
H8! I have to solve an issue, I think it%s easy to do it, but I%m not getting the results I supposed to!!! I have to show in a report, customers who have increased in ales revenue between two dates! I%m trying first with e9fashion universe in order to understand how could I do that, for example, showing what tates have increased ales revenue measure in 78, comparing with 77! =he results should show all tates but Illinois and D$ (they didn%t increase between 77 and 78)! 2s I understand, I should use a subCuery this wayG
ales revenue Treather than 255 ales revenue
where 1ear : 77 &ut, that way the Cuery doesn%t recover any dataKK I%ve tried typing 1ear : 78 in subCuery instead, but neither it wor ked!
3aybe my mind is already on holiday!!! could anyone give me some light o n thisM olG I think you need to design a variable to play around,try bulding belwo formula! customer where sale revenue in 77Fsales revenue in 78!
=his the logic which I have tried writing,you need to convert the same in technical formula!
H4! I used Waggregate aware function for some of my measures! "hen I do aggregate navigation, none of the objects are being checked for incompatibility! what is the solution for this as I don%t have any time or region cols in my table to understand which cols will be compatible or not! olG uggest you to go through 2ggregate aware concept forts which will help you out !
HP! I have column in string format and i need to change that to date format but is giving Lerror message! =he example for column value is Jun 6 and the syntax used is todate(date column,0mmSyyyy0)! $ould you help me out on this !
olG =ry this, Code:
=ToDate([Object];"Mmm yy")
I have a variable named balance and object as 2ccount Number! I need to count those account number only where balace is greater than Vero! I tried below code and both is showing LE##'# in the column!Code:
=Count([Account Number])Where([Account Balance]<>0)
Code:
=Count([Account Number])Where([Account Balance]>0)
olG =ry this9 Code:
'r
Code:
=If([Account Balance]>0;Count([Account Number]))
=his is just to find why actually the one you created is not working, else what others provide you , should also work!
H;! I have a dimension .time spent/ which contains minutes! Now i need to convert that .time spent/ value into hhGmm format! how can i do thisM
olG =ry this Code:
=FormatNumber(Floor([Duration (Minutes)] /60) ;"00") + ":" + FormatNumber(Floor(Mod([Duration (Minutes)];60)) ;"00")
H?! I have a report which is sectioned by client id! &ut I need to access other client ids in the section which is driven by another client id! -or example if I am in a section for client id 6! I want to access (and also display) records for client id 66! Is it possible to do so and howM
olG you can try this idea, not sure if this would work! 1ou can create a variable for the detail you want to fetch for other client ID, lets say .name/ as
Code:
=[name] in Report where ([client ID] in Report = 001)
you can even play around with the function called No-ilter()! ee if it gets you anywhere!.Scode/ HH! am trying to produce a list of people that attended our department more than once within a ? day
period over a specific time of our choice, say 6 month, all the data is stored in the same universe, so if for example a person attends on the 68th, 6Pth, 6?th R 7?th of the month i would need to know the details for the visit on the 6Pth and the 6?th! Each person has a uniCue identifier and
also a uniCue identifier for the visit! I don%t know where to start with this one, if someone has come across this before or can point me in the right direction that would be much appreciatedK olG If you have the dates field, you can create a variable to get w eeks and then sum the visits as per the week!In this way you can get number of visits from the sum!
H! 3y report is sectioned by month9year which I converted from 111133 number to 3on9yy format! =he problem I facing is that in the exported pdf it is showing me the same original number instead of $onverted 3on911! e!g! In my report is getting date is in 111133 format i!e! 766P fo r 3ay966 month! =he report is displaying data correctly but in the exported pdf it is showing me original no! i!e! 766P instead of 3ay966! $an anyone help me sort out this problemM
olG &ookmarks are created based on the d istinct values of the dimension that makes sections! 1ou can then change these values so they appear differently on the report, however, the original values that create sections (and bookmarks too) stay the same!
! I have a report that is sectioned by $lient Id! "ithin the section I need to write formulae to refer to this value so for example in the section for client id 6 I need to write formulae which make decisions if another Id is eCual or not eCual to 6! +ow can I capture this value of 6! lse remember the report has multiple client ids so I cannot hard code the client ids!
olG "ithin a section, everything is filtered for the particular value of the dimension that forms the section! o if the dimension $lient ID was used to create sections then every section has only one value of the $lient ID! =ry it in a free9standing cell!
6! "hen I try to export a line graph report from "ebI to Excel, the values for the @ R 1 axis doesn%t get displayed in the Excel, just the chart with lines is displayed!
o I have to manually goto design9chart layouts in the excel to make the values get displayed! Is there a way to make it get displayed with the values automatically, so that it is easy for the users to view it correctly right after they open the reportM
olG I am having a report with graph and am getting data displayed in excel as well! =ry increasing the width of graph and check!
7! I have a reCuirement wherein when the user enters a from dateS to date range that is greater than 8 months, the "ebi report should be prevented from running somehow, and the user should be advised to select a smaller range for the report! ince we could not find an inherent functionality in &' for this, we are planning to go with java validation screens from which an opendocument url will be used to invoke the report!
=he issue is, even if the user is p revented from entering a larger date range f rom the java screen front end, once the user is in the infoview portal, heSshe can stil l manually change the prompt and refresh the report again by overriding the prompts passed thru opendoc! "e need to prevent this and enable the user only to refresh the report for the prompts that were passed thru opendoc! is there any way to accomplish thisM Disabling refresh capability at admin level is not considered an option currently! $an you advise what needs to be doneM "e are using @I# 8!6 7! kindly let me know if you need more info!
olG 'ther work around, "e can display the message if the end date prompt which is selected exceeds 8 months by using a formula in the report! =hat message you are displaying should tell the user to refresh the report by changing the end date as it is exceeding the given limit!
2lso you can customiQe a date filter specify to this report and default it to a dummy date for which there are no records if the Wrompt date entered is of a large range! $ustomiQe the filter in the universe by employing a case when logic and default to 6S6S6
8! I have a table which have currency EU# to UD, and also 31# to EU#, is it possible for &'&J to calculate for 31# to UD based on the informationM
olG 5ogically, you should be able to do it! -or ex consider your first table (EU# 9 UD)G @ EU# : 1 UD
Now, consider your second table (31# 9 EU#)G V 31# : @ EU#
Joining on EU# column, you would getG V 31# : @ EU# : 1 UD
It depends how the data is stored in the two tables (the grain of the table, whether it is just a snapshot factSfact9less fact table or it contains all values, which will also define the join type)! 4! +ow to display Date and ime prompted in reportG
I have start date and end date prompts, I want to display the both date and time in report! I am using,
:0Date #ange tart0>0G 0 >=oDate(=rim(If(os(User#esponse(0Enter Date =aken(tart)G0)<0 0) : <ubstr(User#esponse(0Enter Date =aken(tart)G0)<6<6)<ubstr(User#esponse(0Enter Date =aken(tart)G0)<6<os(User#esponse(0Enter Date =aken(tart)G0)<0 0) )))<033SddSyyyy0)
Its only showing Date, but its not showing time! +ow to do thatM 2nd where(is it -ree standing cell) to put these information
olG It%s not showing the time because you are telling it to only show the date by substringing only the first 6 characters and formatting it as 33SddSyyyy!
If you want the time element, just concatenate the whole of the user responseG
(pseudocode) :0Date #ange tartG 0 > first user response > 0 to 0 > second user response! P! $an any one tell me how to remove underline of freestanding cell!
olG =he underline is actually a bo rder, click the free standing cell and go to its properties then change its border to remove it!
;! I wish to display a runningsum for the year to date in a report block that is filtered by week number, my report block will o nly ever show the latest week and the ; previous, i want the formula to allways sum from week 6
olG I have calculated the 1=D value based on fiscal year and calender month prompt using the following measure! +ere the fiscal year should be a mandatory prompt!
:If(User#esponse(0Enter 56 $alendar 1earS3onth
*eyG0):00<-ormatDate($urrentDate()<033Syyyy0)<User#esponse(0Enter 56 $alendar 1earS3onth *eyG0))
um(.&ase rc Imp =urnovr/) "here (=oDate(06S0>.56 $alendar 1earS3onth *ey/<0ddS33Syyyy0) F: =oDate(06S0>.$al 3onth rompt/<0ddS33Syyyy0))
?! I am getting an error when i try to install webi rich client to my local machine!&elow is the error message! $#$ failed in packageXlangsXdaX647!mst! It downloads the file and then when the installtion starts I am getting the error!
olG =ry downloading the $ lient =ools again! 5ooks like the one o f the setup files in corrupted!
H! I have a dimension .time spent/ which contains minutes! Now i need to convert that .time spent/ value into hhGmm format! how can i do thisM
olG
Code:
=FormatNumber(Floor([Duration (Minutes)] /60) ;"00") + ":" + FormatNumber(Floor(Mod([Duration (Minutes)];60)) ;"00")
00 is used as the 7nd parameter of the -ormatNumber() function! It has nothing to d o with the 3od() and -loor() functions!
! I have around H Input $ontrols in a "ebi #eport (BersionG &' 8!6 4)! =he order of the input controls keeps changing every time I open the report! Is there any way to restrict this to display in the order they have been createdM
olG I ordered the input controls in "ebI using'Move selected input control up/down' arrow keys and this has solved the problem!
6! I need to show the U3 of two measure values corresponding to two different Dimension and in two different =ables, in the =hirs table! Ex 9
=able 6
#etail Z &usiness 2&$ Z 7
=able 7 &anking Z &usiness E-T Z 8 =able 8 =otal &usiness P
here we have to show the sum of #etail and &anking(i!e, 7>8:P) in the =able 8! olG =ry this9
Code:
=(Sum([Retail] ForAll ([Business]))+Sum([Banking] ForAll ([Business])))
"here #etail R &anking are measure objects and &anking is a dimension which has different values in the report and if you are putting any report level filter and you need that amount also in the
calculation , you might need to use In #eport also! Code:
=(Sum([Retail] ForAll ([Business])) In Report+Sum([Banking] ForAll ([Business])) In Report)
66! I have a "ebI report with 8 pages! "hen I view the report its directly going to third page! "hile navigating from last page to first page, its throwing error and not going to first page! 01our reCuest could not be completed because a failure occured while the repo rt was being processed0 and also 0the document instance is no longer available0!
&ut when I change the view o ption from 0age 3ode0 to 0Draft 3ode0, I am able to see the full report! If I change it to age 3ode again, its throwing error and just showing 8rd page!
