Element not found in dimension error in TI process

[hunterforcognos]

Hi Experts,

I am executing a TI process to load accounts dimension. However, I get the following error when I try to execute the TI process:

Capture.PNG (75.57 KiB) Viewed 5032 times

Can someone please shed some light?

Thanks in advance.

[tomok]

Did you actually read any of the messages in the log??????? I think it's pretty obvious, you have a bunch of records in your data file, which you are trying to load to a cube via some code on Line 6 of your Data tab, and the accounts don't exist in your "Account" dimension. Pretty basic stuff.

[declanr]

You haven't populated your "account" dimension with those account elements before it gets to the data tab and tries to process values against those elements.

Depending on your data source and a number of other factors it would *probably* (but I can't be certain of that without knowing more about what you are doing) be sensible for you to have a section in the metadata tab of this process that adds those accounts in.


Your options simply though are:

A/ Add the elements first in this process
B/ Add the elements first in ANOTHER process (or manually etc it doesn't really matter how you do it)
C/ At the top of the data tab perform a good ol'

Code: Select all

If ( Dimix ( 'Account', vAccount ) = 0 );
     ItemSkip;
EndIf;

D through Z/ A load of other options