Xcelsius Dashboards

Retrying a Failed Transaction

2012-01-31T10:23:00.003+05:30

After an exception is raised, rather than abandon your transaction, you might want to retry it. The technique is:Encase the transaction in a sub-block.Place the sub-block inside a loop that repeats the transaction.Before starting the transaction, mark a savepoint. If the transaction succeeds, commit, then exit from the loop. If the transaction fails, control transfers to the exception handler,

Handling Exceptions Raised in Declarations

2012-01-31T10:18:00.001+05:30

SET SERVEROUTPUT ON;DECLARE BEGIN DECLARE credit_limit CONSTANT NUMBER(3) := 5000; -- raises an exception BEGIN NULL; EXCEPTION WHEN OTHERS THEN -- Cannot catch the exception. This handler is never called. dbms_output.put_line('Can''t handle an exception in a declaration.'); END; EXCEPTION WHEN OTHERS THEN -- Cannot catch the

To implement BEx Key Date at BO Universe

2009-09-18T12:33:00.024+05:30

1. Make a predefined Filter At Universe with the following definitionName of predefined Filter: KeyDateWhere Clause : 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 ->

Error On LOV Refresh in WebI - ERR_WIS_30270

2009-09-14T15:39:00.004+05:30

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

2009-09-12T18:27:00.010+05:30

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

My Learnings from Xcelsius Project

2009-08-20T14:45:00.005+05:30

1. Do not change the name of the sheets once the components mapped otherwise Xcelsius file will not open next time2. 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,

Xcelsius Dashboard from WebI report (with prompt) using LiveOffice

2009-07-20T11:34:00.001+05:30

Environment Details:BOXI R3.1 SAP BI BackendLive Office XI R3.1Xcelsius 20081. 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 objects2. Now create the report with prompt (Customer Key in this case) and export this report to CMS, in