Search found 46 matches

by CiskoWalt
Fri Nov 08, 2013 8:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel - Recalculate workbook before Saving
Replies: 1
Views: 1347

Excel - Recalculate workbook before Saving

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 ...
by CiskoWalt
Mon Aug 26, 2013 8:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Use DBSW
Replies: 19
Views: 7266

How to Use DBSW

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. Ho...
by CiskoWalt
Mon Aug 26, 2013 6:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Use DBSW
Replies: 19
Views: 7266

Re: How to Use DBSW

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
PULL_DBRW.png
PULL_DBRW.png (159.62 KiB) Viewed 6532 times

In the second worksheet, I use DBSW formula to send

Pressing SHIFT + F9 in the send Worksheet will only provide RECALC-###
SEND_DBSW.png
SEND_DBSW.png (150.16 KiB) Viewed 6532 times
by CiskoWalt
Tue Aug 20, 2013 8:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Use DBSW
Replies: 19
Views: 7266

Re: How to Use DBSW

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: 1. have t...
by CiskoWalt
Thu Aug 15, 2013 8:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Use DBSW
Replies: 19
Views: 7266

How to Use DBSW

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 ...
by CiskoWalt
Fri Jul 26, 2013 7:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AutoCalc - set to Manual
Replies: 1
Views: 988

AutoCalc - set to Manual

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...
by CiskoWalt
Thu May 30, 2013 8:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubSet for Date Range - MDX
Replies: 6
Views: 2731

SubSet for Date Range - MDX

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'...
by CiskoWalt
Wed May 29, 2013 1:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubSet for Date Range - MDX
Replies: 6
Views: 2731

Re: SubSet for Date Range - MDX

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

Hierarchy.png
Hierarchy.png (67.23 KiB) Viewed 2687 times
by CiskoWalt
Wed May 29, 2013 1:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubSet for Date Range - MDX
Replies: 6
Views: 2731

Re: SubSet for Date Range - MDX

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...
by CiskoWalt
Tue May 28, 2013 6:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubSet for Date Range - MDX
Replies: 6
Views: 2731

SubSet for Date Range - MDX

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...
by CiskoWalt
Wed Apr 03, 2013 4:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 'Trace Feeders' contradicts 'Check Feeders'
Replies: 3
Views: 1779

Re: 'Trace Feeders' contradicts 'Check Feeders'

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...
by CiskoWalt
Tue Apr 02, 2013 8:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 'Trace Feeders' contradicts 'Check Feeders'
Replies: 3
Views: 1779

'Trace Feeders' contradicts 'Check Feeders'

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...
by CiskoWalt
Wed Feb 06, 2013 7:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Measure of Chid row Applied to Parent
Replies: 3
Views: 503

Re: String Measure of Chid row Applied to Parent

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', ......
by CiskoWalt
Tue Feb 05, 2013 8:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Measure of Chid row Applied to Parent
Replies: 3
Views: 503

String Measure of Chid row Applied to Parent

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 Service Dim C...
by CiskoWalt
Thu Sep 06, 2012 7:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding N-Level Elements to Considation Fails
Replies: 4
Views: 908

Adding N-Level Elements to Considation Fails

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...
by CiskoWalt
Thu Aug 09, 2012 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Separate Dimension or Hierarchy
Replies: 3
Views: 575

Separate Dimension or Hierarchy

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? ...
by CiskoWalt
Thu Aug 02, 2012 7:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Integrating TM1 With Oracle General Ledger 12
Replies: 5
Views: 1279

Integrating TM1 With Oracle General Ledger 12

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...
by CiskoWalt
Tue Jun 05, 2012 8:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Accumulate Measure up to Prior Period
Replies: 2
Views: 1062

Accumulate Measure up to Prior Period

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...
by CiskoWalt
Tue May 01, 2012 6:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Integrating TM1 With Oracle General Ledger 12
Replies: 5
Views: 1279

Integrating TM1 With Oracle General Ledger 12

Thanks Andy.

I'll let you know what I find.

Walt
by CiskoWalt
Mon Apr 30, 2012 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Integrating TM1 With Oracle General Ledger 12
Replies: 5
Views: 1279

Integrating TM1 With Oracle General Ledger 12

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