Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: anilkumar on 29 Jul 2009 03:30:45 AM

Title: mandatory columns missing "dimension name'(very urgent)
Post by: anilkumar on 29 Jul 2009 03:30:45 AM
Hi guys

iam up loading the access table in contrbutor, but iam getting error like'mandatory columns'missing'

please help me out.

thanks in advance
Regards
anil kumar
Title: Re: mandatory columns missing "dimension name'(very urgent)
Post by: maxter on 29 Jul 2009 08:08:30 AM
Problem(Abstract)
When importing an access table from a file, you receive the following error. 
 
Symptom
Mandatory columns missing "DimensionName". 
 
Cause
Ensure that the dimension names (columns) within the import file are spelled correctly, and with the proper case sensitivity as states in the Analyst model. 
 

Resolving the problem
A valid import file must contain the following columns:
A column for every dimension that the access table will apply to (mandatory).
The names of dimension items must be identical in spelling and case to the way they are in the Analyst model.
A column containing e.List items . If omitted, the access level applies to the whole e.List.
A column containing access levels (optional). The following access levels can be set HIDDEN, READ, WRITE, NO DATA (these are not case sensitive). If omitted, a default of WRITE will apply. 

http://www-01.ibm.com/support/docview.wss?uid=swg21346299
Text only | Text with Images