Skip to main content

Line Item Deatils not copying over with Versioning


Technote (troubleshooting)


Problem(Abstract)

Although the option to copy LIDs is selected with versioning, and confirmation is recieved that LID's were copied, the versioning results do not display any LIDs.

Symptom

No LIDs displayed in versioning results


Cause

Cube and dim references incorrect in the versioning script.

Diagnosing the problem

1) Confirm the xml used to configure versioning.

-Administration>Security Services>Menu Administration

-Modeling>Versioning>Edit menu Details

-check the Document Location, open versioning.xml

2) Check the LID script (In the default versioning xml, this is <scriptgroup id="sql2">)

3) Note the cube (Database) being used through OLAP Manager

4) Confirm the CubeID (cube from previous step) in the dbo.Cubes table (relational) in the Clarity database.

5) Based on the CubeID, retrieve the dimensionIDs from the dbo.Dimensions table.

6) Confirm the CubeID and DimID references are correct.

Resolving the problem

Update the LID script with the correct cubeID and dimensionIDs

Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

Clarity 7

Clarity Server


Software version:
7.0, 7.2, 7.2.1


Operating system(s):
Windows


Software edition:
All Editions


Reference #:
1622523


Modified date:
2013-01-16

Translate my page

Content navigation