To implement BEx Key Date at BO Universe

1. Make a predefined Filter At Universe with the following definition
Name of predefined Filter: KeyDate
Where Clause : <filter key="[0P_ECKDT]"><condition key="[0P_ECKDT]" operatorcondition="Equal" tech_name="@Prompt('Key Date','D',,,)"/><CONDITION></FILTER>

Note : [0P_ECKDT] is the technical name of key date object in SAP BW for key date

2. Check the option “Use filter as mandatory in query -> Apply on Universe” so that key date should be asked every time user executes the query.


3. In Universe Parameters , set the “KEYDATE_ENABLED” to “No”, as shown in below image

Now the keydate will appear as normal prompt in webI documents and you can use them in xcelsius by using prompt binding.

Error On LOV Refresh in WebI - ERR_WIS_30270

For Error "ERR_WIS_30270" follow the following steps. I faced this problem while refreshing the LOVs in webI reports.

Select All the Check boxes in “Associate a List of Values” section except “Delegate Search”



Although I used this solution, But I am not sure about the reason ebhind this.

Simultaneous Refreshing More Than 1 LiveOffice in Xcelsius

1.Insert LiveOffice Connections in Xcelsius, say you inserted Live1, Live2 and Live3. In this example they are LO_OP_PlantParamterts_Yearly_C Actual (Live1), LO_OP_PlantParamterts_Monthly_C Actual (Live2) and LO_OP_PlantParamterts_Last7Days_C Actual (Live3)

2.For the first connection in chain set “Refresh on Trigger-> Refresh Cell” to the cell where you are storing the input from the user, say It is Company Name and Brand Name and your are using Filter component to ask the values from user.

3.Select “When Cell Updates” option.

4.Set “Loading Message” to “x” (Value which you will never user)

5.Set “Idle Message” to 1 and insert it into a cell say “D2”, as shown in below image



6.Now, set the Usage Options for the 2nd Live Office connection (Live2). Set “Refresh on Trigger-> Refresh Cell” to the cell where you are storing the “Idle Message” of the Live Office connection1 (Live1)

7.Select “When Value Equals” option and enter the value which you inserted in Idle Message of connection Live1. In this case it is 1

8.Set “Loading Message” to “x” (Value which you will never user)

9.Set “Idle Message” to 2 and insert it into a cell say “D3”, as shown in below image



10.Now, set the Usage Options for the 3rd Live Office connection (Live3). Set “Refresh on Trigger-> Refresh Cell” to the cell where you are storing the “Idle Message” of the Live Office connection2 (Live2)

11.Select “When Value Equals” option and enter the value which you inserted in Idle Message of connection Live2. In this case it is 2

12.Set “Loading Message” to “x” (Value which you will never user)

13.Set “Idle Message” to 3 and insert it into a cell say “D4”, as shown in below image


Same steps can be repeated for as many connections as you want. I have used 8 live office connection to refresh with same logic.

My Learnings from Xcelsius Project

1. Do not change the name of the sheets once the components mapped otherwise Xcelsius file will not open next time
2. Do not use the " Disable Mouse Input on Load" option when using Clender component in dashboard. Doing this will make calender hanged and multiple dates will be selected, thus value will not update in binded cell.
3. Excel formulas cant be written using reference of LiveOffice rows, as LiveOffice deletes the old rows and then insert new rows while Refreshing. But while using these liveoffice excels, in Xcelsius 2008, which contains formulae and referencing to the liveoffice data cells, formulae work correctly.
4. Always use Detail objects in SAP Cube/BEx based universes, while filtering data in WebI report. It could happen that you are using Dimension Object and at the time of using it there is no TEXT available for the Key then you can filter on Key, but later on if there will be data in Cube for the field against the key you had used and text for that InfoObject in cube is enabled, then your query won't filter results correctly. For e.g. I have One dimension object in universe Employement Type which I was filtering in WebI as, Employement Type : 3 (3 means Active), but later on in cube value against this key is entered and Text is made enabled at InfoObject level, my WebI qury is not filtering and I had changed it to Employement Type : Active, and my WebI then worked correctly.

5. Do not refresh more then one the LiveOffice connections in Xcelsius dashboard simultaneoulsy, must referesh them in serial oreder. Try some logic to refresh them in serial order as I used Idle and Loading messages as flags to know the refresh status of previuos connection and submit the next connection refresh only after previous liveoffice successfully refreshed. For details write to me and add your email I will send you the sample Xcelsius file.

Please add-on more :)

Xcelsius Dashboard from WebI report (with prompt) using LiveOffice

Environment Details:
BOXI R3.1

SAP BI Backend
Live Office XI R3.1
Xcelsius 2008

1. Create webI report for prompt display values which will be used to get input from user in Xcelsius Dashboard. Let this report is exported to CMS with name “prompt values”
Note: Use Detail values instead of dimension objects



2. Now create the report with prompt (Customer Key in this case) and export this report to CMS, in this case report name is “Test Webi Report(1)”

3. Now insert these webI documents in Excel using Live office
First insert the prompt values webi report

5. Now Import webI report which contains the dashboard data.

6. Refresh all the connections

7. Select webI report contains dashboard data.



8. Bind the prompt with excel cell



9. Select “Choose Excel data range” option and bound one excel cell (B18 in this case) with prompt values.
Note: Unselect “Append parameter list to the dropdown of the binding cell” if you don’t want list of values to he displayed as drop down box in excel sheet.



Test the connection change the value (from ‘10007 to ‘10008 for this case, may the value will be different in your case so select accordingly) in selected cell and check if the data is getting refreshed, if yes, then you have successfully created WebI – LO Connection and it is ready to be used in Xcelsius 2008.

10. Save this excel sheet on your machine.

11. Open Xcelsius and import above saved excel sheet as data source



12. Goto Data->Connections menu and Add Live Office connection
Note: Must not forget to enter your webserver name/IP address where BOBJ is installed.



13. On usage Tab of Live Office connection which is being used to get dashboard data , set options “Refresh On Load” and “Refresh on Trigger” and select the cell where we bounded the prompt values (B18) in this case.



14. Now select List Box (You also can use some other control as per the requirement) and give it Label range (C5 to C16 in this case) from the prompt values which we had selected in WebI report “prompts values”
In Source give full range of prompt values and in destination must include which is bounded to webI prompt (B18).



15. Add One more control (dial in this case) and set its value from dashboard data. Its value must be changed as we select different customers from the list box we created



16. Preview the file, enter credentials and data should be updated as you select different customers.

17.Export it to CMS and open it from Infoview.

Please revert back if you any problem.

Enjoy
Sandeep Manocha