Changes in Cube Manager are not flowing over to the cube.

Technote (troubleshooting)


Problem(Abstract)

When the user makes a change in Cube Manager, the changes are reflected in the relational database but not in the cube.

Symptom

Changes are not registered in the OLAP cube after saving in Cube Manager. This can be identified in Clarity Studio or Analysis Services.


Cause

Service Broker was disabled for the database.

Diagnosing the problem

- Ensure that the jobs were being fired off by running SQL profiler

- Make a change in cube manager and see if the data is being populated in following tables: cm_audit , tbl_log_applicationprocess, tbl_integration_events.
- Check to see if processtimestamp column stays null or is populated. This will tell you if the store procedure that populates is being kicked off or not.
- Check Service Broker on the database to see if it is enabled.
- Right click on the database and select Properties
- Scroll down to see under Service Broker, to see if Broker enabled is true or false. (Should be true).
- Trustworthy also needs to be enabled.


Rate this page:

(0 users)Average rating

Document information


More support for:

Clarity 7
Clarity Server

Software version:

7.2.1

Operating system(s):

Windows

Software edition:

Standard

Reference #:

1650817

Modified date:

2013-09-23

Translate my page

Machine Translation

Content navigation