Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

 Calculated Members - What to do if I cannot find my calculated member in the Viewer

For performance reasons, CXO-Viewer caches meta-data on dimensions. This cache should be refreshed as soon as meta-data has been changed. A refresh of the cache can be forced by putting the string “&refresh=true” at the end of the url.

For example:

 

http://Myserver/CXOViewer/ViewerLogin.aspx?ViewerId=ab5c9880-1bfe-4e8.......nC2PTlzq&refresh=true

 

This is a one time action and it is even sufficient that one user (e.g., the admin user) performs this action.

 CXO-Cockpit Print Server - How should I configure it

In order to configure CXO-Cockpit Print Server you need to go to the folder where it is installed and open the file called CXO.Cockpit.WindowsServices.StoryBoardGenerator.exe.config.

Applications

First you need to specify which applications should be handled by the current instance of the CXO-Cockpit Print Server.

Find a section called ConnectionStrings and add new applications. Keep in mind that the <clear /> statement should stay in there. Te easiest way to find an appropriate connection string for you application is to copy it from the Web.config file of your website.

Finally the ConnectionString section should look like this:

 

<connectionStrings>
  <clear />
  <add name="GAPConnectionString_prod" connectionString="Data Source=SQLSERVERINSTANCE;Initial Catalog=cxo_repository_prod;Integrated Security=False;user=SQLUSER;password=ENCRYPTEDSQLPASSWORD" />
</connectionStrings>

 

 

Navigate through the file and find a section called appSettings. It is not recommended to change all of this settings but you probably need to change the following:Configuration

  • FileStoreLocation - the folder where the CXO-Cockpit Print Server will store all generated files
  • CXOViewerUrl - the URL of the CXO-Viewer in your current setup
  • RenderingEngine - the rendering engine which will be used for creating an export. Can be IE (Internet Explorer) or FF (Firefox)

In most of the cases the following configuration will work:

 

<add key="FileStoreLocation" value="C:\Program Files\CXO Solutions\CXO-Cockpit\Storyboard Export Service\files\" />
<add key="CXOViewerUrl" value="http://localhost/CXOViewer/" />
<add key="RenderingEngine" value="FF" />

 

 {Expand

 Financial Statement - How can I manage the breakdown dimensions in the report

CXO-Cockpit is closely integrated with your source system and retrieves from your source system which analytical dimensions have a relation to the selected account.

You would normally see no analytical dimensions that have no relation with the selected account.

In order to open the report with the most relevant analytical dimension you can set the ´Default Breakdown Dimension´ parameter.

As of 4.3.2 release there is an option to display account breakdown in Member Detail Control of the Financial Statement report. If Account dimension is one of the report breakdown dimensions, the sub-accounts of the selected account will be displayed according to their hierarchy in the right bottom pane of the report:

See Also

Financial Statement Template

 Financial Statement - I don´t like the variance bars, can I change the chart style or remove the variances

Yes there are several ways to change the variance bars that are displayed by default:

  1. Change the report to use boxes instead of bars --> change the ´Variance Style´ parameter to: boxes
  2. Hide the variance bars completely --> change the ´Variance Style´ parameter to: none
  3. Hide the variance on those lines where it is not relevant: --> Set the ´Suppress Variance´ attribute of the specific row item to: Yes

See Also

Financial Statement Template

 For the commentary sections in the dashboard tool, is it possible to create a template format

Yes, CXO-Cockpit provides an option to prepare a template for the users, so that they have a fixed format to enter the comments. See for an example the following screenshot:

 HFM data-extract: why do selected dimension members not show up

This usually happens if you added new Custom# dimension members, new Accounts or new Entities to HFM. After you retrieved the new meta-data in the CXO-Cockpit by starting a Meta-data extract, you select the new members and you hope that they will also be available to the reports.

The reason that they do not show up is because you did not do a full-data extract, followed by a full OLAP database processing after selecting the new members. Either you did not do a data extract at all, or you only did an incremental upload (certain Scenario / year / period combinations).

Only after a full data-extract (a data-extract using the first Load Set) the dimensions in the CXO-Cockpit are rebuilt. And only after a full processing of the OLAP database (so with the 'Data only' checkbox under the 'Process OLAP db' button unchecked) the new members will be selectable and / or visible in the CXO-Cockpit reports.

  • No labels