Search found 83 matches

by lynnsong986
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: 299

Re: Copy element attributes from one dimension to another

Thank you so much for your help! I'm going to try it out!
by lynnsong986
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: 299

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 my dimensions have different levels. I'...
by lynnsong986
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: 395

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!
by lynnsong986
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: 395

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?
by lynnsong986
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: 395

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" exist in both Tax_Meas and StatementLine di...
by lynnsong986
Wed Jan 01, 2020 8:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: filter by attribute greyed out?
Replies: 2
Views: 731

Re: filter by attribute greyed out?

somehow it worked today! I guess I'm good for now...thanks Wim!
by lynnsong986
Tue Dec 31, 2019 7:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: filter by attribute greyed out?
Replies: 2
Views: 731

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 someone please l...
by lynnsong986
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: 1401

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...
by lynnsong986
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: 727

Re: Circular reference in a financial model

oh wow I never thought of circumventing formulas like that, you are a genius! thanks a ton!!
by lynnsong986
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: 727

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...
by lynnsong986
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: 735

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 ...
by lynnsong986
Fri Nov 08, 2019 1:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock codes
Replies: 5
Views: 1739

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!
by lynnsong986
Fri Nov 08, 2019 1:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about DimensionElementInsertDirect
Replies: 7
Views: 3894

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!!
by lynnsong986
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: 591

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!
by lynnsong986
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: 591

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!
by lynnsong986
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: 591

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!
by lynnsong986
Wed Nov 06, 2019 7:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess not working
Replies: 6
Views: 1298

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!
by lynnsong986
Wed Nov 06, 2019 6:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess not working
Replies: 6
Views: 1298

Re: ExecuteProcess not working

Here is the error messages...
by lynnsong986
Wed Nov 06, 2019 6:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess not working
Replies: 6
Views: 1298

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 ...