Troubleshooting
Problem
Error encountered building Powercube with Powerplay Transformer.
(TR2317) The level 'Fiscal Date' is designated as unique.
Source value '99991232' was used in an attempt to create a category path in the path
Symptom
A unique Category in a Time Dimension is attempting to create a Category with the Category Code '99991232'.
The Date Dec. 32nd 9999 is not a valid date and is not a date that is present in the Data Source that is used to populate the time Dimension.
Cause
The Time dimension is configured with a Latest Date that is earlier than the data in the Data Source that is used to populate the Time Dimension.
Resolving The Problem
Set a latest Date that is later than the data used to populate the Dimension.
In the Transformer Model, right-click the Time Dimension and select Properties, Time tab.
In the Latest Date field, set a Date that is later than the data in the Data Source that is used to populate the Time Dimension.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m0z000000bp35AAA","label":"Modeling->Transformer"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
14 October 2020
UID
ibm16348214