Error/Warnings in TI

Post Reply
mincharug.shulft
Regular Participant
Posts: 155
Joined: Fri May 20, 2011 8:17 am
OLAP Product: Applix,Cognos TM!
Version: applix9.0Cognos tm1 9.5.1
Excel Version: Excel 2010 2007

Error/Warnings in TI

Post by mincharug.shulft »

i would apprciate for your help here.
I have build some calculations using TI process, and also i passed the parameters(in TI under Parameters TAB ,there are three paramaeters)
so once the Processes completes with error warnings and iam not entirley sure what is mean of. Could you please help me to understand why these are occuring. Listed below are just a few examples coming from log file.
and also i have taken the Maps TAB and under Cube TAB i have enabled the NO Action,Accumulate Values ..

"calulation","Abdabi","entrie","satity","central","EN","PAK",Data Source line (1) Error: Data procedure line (94): Invalid key: Dimension Name: "regions", Element Name (Key): "Trades"
"calulation","Abdabi","entrie","satity","central","EN","PAK",Data Source line (1) Error: Data procedure line (94): Invalid key: Dimension Name: "regions", Element Name (Key): "Trades"
"calulation","Abdabi","entrie","satity","central","EN","PAK",Data Source line (1) Error: Data procedure line (94): Invalid key: Dimension Name: "regions", Element Name (Key): "Trades"
"calulation","Abdabi","entrie","satity","central","EN","PAK",Data Source line (1) Error: Data procedure line (94): Invalid key: Dimension Name: "regions", Element Name (Key): "Trades"

Thanks for understanding me.
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Error/Warnings in TI

Post by Alan Kirk »

mincharug.shulft wrote:i would apprciate for your help here.
I have build some calculations using TI process, and also i passed the parameters(in TI under Parameters TAB ,there are three paramaeters)
so once the Processes completes with error warnings and iam not entirley sure what is mean of. Could you please help me to understand why these are occuring. Listed below are just a few examples coming from log file.

"calulation","Abdabi","entrie","satity","central","EN","PAK",Data Source line (1) Error: Data procedure line (94): Invalid key: Dimension Name: "regions", Element Name (Key): "Trades"
"calulation","Abdabi","entrie","satity","central","EN","PAK",Data Source line (1) Error: Data procedure line (94): Invalid key: Dimension Name: "regions", Element Name (Key): "Trades"
"calulation","Abdabi","entrie","satity","central","EN","PAK",Data Source line (1) Error: Data procedure line (94): Invalid key: Dimension Name: "regions", Element Name (Key): "Trades"
"calulation","Abdabi","entrie","satity","central","EN","PAK",Data Source line (1) Error: Data procedure line (94): Invalid key: Dimension Name: "regions", Element Name (Key): "Trades"

Thanks for understanding me.
It means that you should look at the code on line 94 of your Data tab. It may be a CellPutN or CellGetN function. Whatever it is, it's trying to use an element named "Trades" in an argument which represents the dimension "Regions" in your function. No element named "Trades" actually exists in that dimension.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
mincharug.shulft
Regular Participant
Posts: 155
Joined: Fri May 20, 2011 8:17 am
OLAP Product: Applix,Cognos TM!
Version: applix9.0Cognos tm1 9.5.1
Excel Version: Excel 2010 2007

Re: Error/Warnings in TI

Post by mincharug.shulft »

Thank you so much for your quick reply.

exatly iam using the CellGetN function and i will back to you once i analzed and kindly let me know if anything that i have look.


Thanks.
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Error/Warnings in TI

Post by lotsaram »

mincharug.shulft wrote:"calulation","Abdabi","entrie","satity","central","EN","PAK",Data Source line (1) Error: Data procedure line (94): Invalid key: Dimension Name: "regions", Element Name (Key): "Trades"
Assuming that the error file extract is verbatim and contains a complete set of the source file variables (which I assume is the case since you included multiple rows) then one additional thing worth mentioning is that the value "Trades" is not contained in the data source itself and so is coming either from a parameter or variable that has been created.
mincharug.shulft
Regular Participant
Posts: 155
Joined: Fri May 20, 2011 8:17 am
OLAP Product: Applix,Cognos TM!
Version: applix9.0Cognos tm1 9.5.1
Excel Version: Excel 2010 2007

Re: Error/Warnings in TI

Post by mincharug.shulft »

All ,
Thanks for your valuable reply ,i reached as i expected.
Post Reply