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.
Error/Warnings in TI
-
- 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
-
- 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
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.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.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
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.
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.
-
- 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
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 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"
-
- 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
All ,
Thanks for your valuable reply ,i reached as i expected.
Thanks for your valuable reply ,i reached as i expected.