Reading MSFT Analysis Services cube with Cognos

[DTaylorPDX]

We are using Cognos to read Microsoft Analysis Services cubes. We have a dimension with a 2 byte code and a 20 byte descriptions. There is a one-to-one correspondence between a code and a description, and we don't want to have two separate levels in the hierarchy--one for the code and one for the description. Cognos can only read what is passed to it, and can't use substring or any other character functions. When passing the full 20 byte description to a query, performance suffers. It improves dramatically when we use the 2 byte code. Is there a way to display the description on the Cognos report, but use the code when querying against the cube to improve performance?

 

[elsey]

hi.You may use label,short name and long name.