Search found 83 matches
- Fri Jan 24, 2020 3:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy element attributes from one dimension to another
- Replies: 2
- Views: 1634
Re: Copy element attributes from one dimension to another
Thank you so much for your help! I'm going to try it out!
- Fri Jan 24, 2020 3:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy element attributes from one dimension to another
- Replies: 2
- Views: 1634
Copy element attributes from one dimension to another
Hello, I have a dimension "Company_BU" where each BU is rolled up into a company. another dimension "BU" has only the BUs not company. I need to copy the Alias attributes of the "Company_BU" dimension to the "BU" dimension. I found some codes on this forum but...
- Thu Jan 09, 2020 2:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem copying data between 2 cubes using TI
- Replies: 3
- Views: 1841
Re: Problem copying data between 2 cubes using TI
Thank you so much lotsaram for your time explaining this to me! I'll definitely give it a try!
- Wed Jan 08, 2020 7:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem copying data between 2 cubes using TI
- Replies: 3
- Views: 1841
Re: Problem copying data between 2 cubes using TI
I created a new cube and use rules to pull the numbers then use TI, it works. I think I know the answer. TI can only read/write from/to leaf-level cells?
- Wed Jan 08, 2020 6:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem copying data between 2 cubes using TI
- Replies: 3
- Views: 1841
Problem copying data between 2 cubes using TI
Hello, I have a source cube "ca_tax" and a target cube "ca_bal_sheet_cash_flow". the source cube has 3 dimensions: Years, Company_BU, Tax_Meas the target cube has 3 dimensions: Years, Company, Statementline "Deferred tax Asset" and "Deferred Tax Liability" exi...
- Wed Jan 01, 2020 8:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: filter by attribute greyed out?
- Replies: 2
- Views: 1902
Re: filter by attribute greyed out?
somehow it worked today! I guess I'm good for now...thanks Wim!
- Tue Dec 31, 2019 7:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: filter by attribute greyed out?
- Replies: 2
- Views: 1902
filter by attribute greyed out?
Hello, I have a dimension named 'statement_line' that has various line items in financial statements (balance sheet, income statement and cash flow statement), somehow the "filter by attribute" in subset editor is greyed out (there are multiple attributes attached to each line), can someon...
- Sun Dec 01, 2019 1:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IBM Cognos gateway unable to connect to BI server
- Replies: 0
- Views: 3218
IBM Cognos gateway unable to connect to BI server
Hello, All of a sudden I got this message when trying to log in. I don't have admin privilege and I couldn't reach the TM1 guy at work on a Saturday... all I care for now is this question - will I lose any work I've done once the server gets back on? I tried to read a few threads online but I really...
- Mon Nov 18, 2019 4:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Circular reference in a financial model
- Replies: 3
- Views: 2656
Re: Circular reference in a financial model
oh wow I never thought of circumventing formulas like that, you are a genius! thanks a ton!!
- Mon Nov 18, 2019 2:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Circular reference in a financial model
- Replies: 3
- Views: 2656
Circular reference in a financial model
Hello, I need some help with a circular reference in TM1 (knowing it is not allowed). Attached is a simplified model where a circular reference exists in excel: interest expense (to simply it I only calculate on short term debt) = STD * interest rate; interest is part of net income that goes into re...
- Sat Nov 09, 2019 8:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Create views/subsets dynamically in a CONTROL object
- Replies: 2
- Views: 2039
Re: Create views/subsets dynamically in a CONTROL object
Thank you so much Wim as usual!!
- Sat Nov 09, 2019 7:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Create views/subsets dynamically in a CONTROL object
- Replies: 2
- Views: 2039
Create views/subsets dynamically in a CONTROL object
Hello, I came across a TI that dynamically creates a view after a bunch of dimensioncreatebyMDX, subsetelementinsert, viewsubsetassign and finally using this newly created view as data source (then copy the data in this view to a target view in data). I understand everything except the part that it ...
- Fri Nov 08, 2019 1:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock codes
- Replies: 5
- Views: 3893
Re: Bedrock codes
Thanks for the link! I'm a beginner and somehow I found Bedrock v3 is a bit easier to understand...very appreciated!
- Fri Nov 08, 2019 1:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Question about DimensionElementInsertDirect
- Replies: 7
- Views: 6901
Re: Question about DimensionElementInsertDirect
Thanks for the info, I don't think I'll use the direct method much at all knowing that I might crush the server!! my online trainer never got back to me on this question...I assume that he knew he didn't explain it correctly in the video haha!!
- Fri Nov 08, 2019 1:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CSV file as data source, why TI is reading one more column?
- Replies: 5
- Views: 2585
Re: CSV file as data source, why TI is reading one more column?
Wow that must be it!! thanks so much for your time letting me know!
- Thu Nov 07, 2019 10:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CSV file as data source, why TI is reading one more column?
- Replies: 5
- Views: 2585
Re: CSV file as data source, why TI is reading one more column?
it's not causing anything really, I just don't understand why it showed up...but I guess I can definitely ignore it sounds like this does happen in TM1... thanks!
- Thu Nov 07, 2019 9:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CSV file as data source, why TI is reading one more column?
- Replies: 5
- Views: 2585
CSV file as data source, why TI is reading one more column?
Hello, I have a CSV file with 12 columns as data source, but the preview shows V1.......all the way up till v13 (all blanks underneath it - v13 is non existing in the CSV, column 13 has absolutely nothing), also there are 13 variables in the Variable tab. How can I get rid of this v13? thanks so much!
- Wed Nov 06, 2019 7:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExecuteProcess not working
- Replies: 6
- Views: 3539
Re: ExecuteProcess not working
The problem is that we work at different work stations and he's super busy...I'll try to find the log files and go from there. Thanks so much!
- Wed Nov 06, 2019 6:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExecuteProcess not working
- Replies: 6
- Views: 3539
Re: ExecuteProcess not working
Here is the error messages...
- Wed Nov 06, 2019 6:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExecuteProcess not working
- Replies: 6
- Views: 3539
Re: ExecuteProcess not working
Did the execution of SampleExport when called by your 1st TI generate a separate log file of the errors it encountered? No I don't think so, it actually worked when I only have a list of names in the CSV name, it generated the CSV reports in the path with the names. but it didn't generate any file ...