TM1 Forum

Hello, I am using TM1 9.5.2 Fix pack 3, with Excel 10, 32- bit. It can take a long time (10- 15 minutes) to save a Financial model when the following 2 conditions are met: 1.There were a significant number of changes made to the model. For example, including inserting new Worksheets or a refresh of ...

Declan Rodger...THANK YOU !!!!! The SNAG IT application mapped my SHIFT + F9 Keys to something else!!! http://feedback.techsmith.com/techsmith/topics/please_give_me_back_the_shift_f9_and_shift_f10_keys Reason: Shift-F9 and Shift-F10 are hard-wired to video capture start & stop, which I never use...

Thanks was on vacation for a few days.

I too am curious why this did not works for me.

In one worksheet, I pull data using DBRW

In the second worksheet, I use DBSW formula to send

Pressing SHIFT + F9 in the send Worksheet will only provide RECALC-###

Folks, I have attached a workbook that makes use of the TM1 sample database named "PDATA" I inserted an element in the actvsbud dimension named SendW01. the workbook just pulls data from the Actual elements and attempts to send it to the SendW01 element. Have tried some of the suggestions:...

Group. See attached. I know that this topic has come up a few times. How do we use DBSW with DBRW functions in the same workbook? When you wish to optimize the users' financial models for the WAN, we are told to use the TM1 functions: VIEW, DBRW, and DBSW. I am able to use the VIEW function and the ...

Hello, I have discovered one reason why Excel workbooks have been auto calculating all worksheets even though the Excel's auto calculate setting is set to Manual. I am working with Excel workbooks that are over 10 years old, and somehow this named ranged was inserted to the old workbook. The workboo...

thanks eveyone for your help. I found a post on this site and followed the same process: 1 Add the TM1 date serial number as an attribure to the Date dimension #^^^ This process maintains a view that is associated with the VodDailySales Cube #^^^ #^^^ #^^^ GLOBAL VARIABLES sCubeRef = 'VodDailySales'...

I think the issue is that there are 2 hierarchies in the VodDay dimension. One for All Years the the other for Relative Times

Evgeny, Thanks for your help. There is no error message. Probably the best way to see that the MDX does not work as expected is to use the 'Expression Window' to view the generated subset: You can see that we used the data range 4/30/2013 to 5/1/2013 but the data returend is all elements from 4/1/20...

Hello, I am using a parameter cube that has a start date and an end date to specify a date range that will be used by an MDX query to populate a dynamic subset. The Dynamic subset will be used by a view to determine which records should be zeroed out before loading data. The paper from Philip Bichar...

Tomok, Thank you. Your suggestion worked. I am not sure why it did not work. New feeder: new_feeder.png Referencing a Consolidation on a feeder is shorthand for 'all n-level' elements under the consolidated element. TM1 does not feed from a consolidated element. Using 'All Departments' is stating fe...

Hello, I have attached a Power Point file. I have a rule that is not Fed. I know it is not fed because when we turn on zero suppression, it disapears; when we right-click on it and select 'check feeders' a value of 'not fed' appears. When I generate a view, in server Explorer, that contains the Feed...

Thank your for your help. Have found that we need to add the 'S:' before the IF. If there is no S: nothing is returned. Best, Walt ___________________________________________________________________________________________________ ['Start Date'] = IF( ELLEV('Month', !Month) <> 0), DB('YourCube', ......

Hello, I have a cube that stores a date as string. Contract Expiration Date "1/25/2013" I have the following dimension that contains customers and contracts All Contracts Contract 1 Customer 1 Customer 2 Customer 3 A second dim that contains the service Service A Service B Customer Dim Ser...

Hello, I have a file that has the following 2 columns of data: MSO Code, Contract Code I am trying to create the following 2 hierarchies within a dim using TI. All MSO (consolidation) MSO Code (consolidation) MSO Code-Contract Code (the n-level) All by Party (consolidation) Contract code (consolidat...

Hello, My question: When is it better to create a dimension rather than a hierarchy within a dimension? What are the trade-offs? Will concatenating codes values make it difficult to drill-down to relational data in the source system? Should the depth of the hierarchy be one of the deciding factors? ...

Here is the SQL I used to pull Opening Balances, 12 Months and YTD data from our Oracle ERP application. You will have to change the WHERE clause. Hope this helps someone. Best, Walt SELECT to_char(gb.period_year) as vsPlanYear ,gcc.segment1 as vsEntity ,gcc.segment2 as vsDept ,gcc.segment3 as vsMaj...

Hello, Would ilke to set up a rule that summarizes data for all previous periods. For example, when the current period is Jan-2010, then the meausue 'Accume Value' should summarize the Value for all months before Jan-2011 and not include future periods, Feb 2011 below. Value Accume value Oct 2010 10...

Thanks Andy.

I'll let you know what I find.

Walt

Hello, I am interested in Integrating TM1 version 9.5.0 64-Bit with the Oracle Financials release 12, running on Oracle 11G. Is there a technical document on this? I have contacted IBM, they do not have one. I am interested in the Oracle table/view names that will be the source of data. Requirement:...