Using Cognos 10.1 Analysis Studio. When I open the package I am getting two issue with two specific dimensions
Issue-1: When I expand the dimension I get error ANS-MES-0003 A server error occurred. Unable to complete the action. I looked through the dimension a number of times and am not able to find anything wrong.
Issue-2: When I expand my dimension. Nothing expands as if there is no items under this dimension. I looked and am not able to find any issue.
Any help or point at the right direction will be appreciated.
Zaib
From FM model containing said package, are you able to view/explore data from that dimension without issue?
From FM when I right click on the dimensions and choose test and able to test the data just fine. I see the right data for both these dimensions.
Are there facts associated with those dimensions? I cannot recall how this works out on DMR, but for cubes if there are no associated facts then the dimensions will not normally display anything. Also, if security filters are being used and the logged in user has no access, you can get that error.
Thank You for your replies...
Further Findings...
I noticed the same behavior, when using Report studio so started looking at this package in FM.
Issue-1: When I expand the dimension I get error ANS-MES-0003 A server error occurred. Unable to complete the action. I looked through the dimension a number of times and am not able to find anything wrong. (I have to replace expression #'[GOSALES].[COUNTRY].[COUNTRY_' + $Language_Lookup{$runLocale} + ']' # with [GOSALES].[COUNTRY].[COUNTRY_EN] for couple of query items. I am not sure why this was causing issue. Any experts advice on this one?)
Issue-2: When I expand my dimension. Nothing expands as if there is no items under this dimension. I looked and am not able to find any issue.(Still Looking)