If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

ANS-MES-0003

Started by zaib, 15 Oct 2013 04:43:24 PM

Previous topic - Next topic

zaib

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

Grim

From FM model containing said package, are you able to view/explore data from that dimension without issue?
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

zaib

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.


bdbits

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.

zaib

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)