Search found 24 matches
- Sun Oct 17, 2010 3:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: start dates and end dates
- Replies: 0
- Views: 1440
start dates and end dates
I have a rows of data from sql defining the month, quarter, year for any given date RANGE. for example, YEAR QTR MONTH START DATE END DATE 2000 1 1 1/1/2000 31/1/2000 Now in my time dimension i have all the dates. So what would be the best way to create the rollups given that for each row in SQL I o...
- Tue Mar 09, 2010 3:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Compare Sandbox in TM1 9.5
- Replies: 4
- Views: 3896
Re: Compare Sandbox in TM1 9.5
You can write a TI that transforms a sandbox to a dimension and use this as a dimension in another cube. A TI will need to move data from the source cube to the target cube. GETACTIVESANDBOX() and USEACTIVESANDBOX() functions in the TI API need to be used.
- Fri Oct 16, 2009 5:27 am
- Forum: Useful code, tips and tricks
- Topic: Averages for Consolidations
- Replies: 7
- Views: 21050
Re: Averages for Consolidations
There is also the "ConsolidateChildren" rule function, which allows you to arrive at a consolidated value across a time or product or whatever dimension that maybe. This is useful when wanting to create a weighted average.
- Sun Nov 16, 2008 6:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: inventory balances
- Replies: 1
- Views: 2477
inventory balances
Hi, I have a request for which I need to store the rolling balances for inventory stock on hand. So basically, I need to roll the closing balance of the previous month as the opening balance of the next month. Since, the data source is at a transaction level the opening balance for each month needs ...
Re: OLAP Jobs
Hi,samy2 wrote:IN need of a BA with OLAP TM1 ESSbase and Microsoft Analystics for Local Houston fulltime opportunity with Energy Company.
Please provide me details of the job description and an email address where I can submit to you my CV.
- Wed Oct 01, 2008 11:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeders to calculate Totals
- Replies: 9
- Views: 7398
Re: Feeders to calculate Totals
Unfortunately, still no luck with this. I tried putting the attribute "prod_cat" on the prod dimension as well.
HMMM.
HMMM.
- Wed Oct 01, 2008 5:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeders to calculate Totals
- Replies: 9
- Views: 7398
Re: Feeders to calculate Totals
That didn't work either. hmm really puzzling me now.
- Wed Oct 01, 2008 2:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeders to calculate Totals
- Replies: 9
- Views: 7398
Re: Feeders to calculate Totals
The trace feeders option is greyed out. I don't think the dimension names are causing the problem. I tried changing the names and still the problem exists.
- Tue Sep 30, 2008 8:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeders to calculate Totals
- Replies: 9
- Views: 7398
Feeders to calculate Totals
Attached is a screenshot in word of the feeder I'm trying to write such that the value at intersection ['total cust - prod', 'Quantity'] of 8334 is fed into the target cube at intersection ['Total Products', 'Total Cust']. The Rule in the target cube is: SKIPCHECK; ['Quantity']=N: DB('Product Cust H...
- Thu Sep 18, 2008 4:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: view - no read access to elements
- Replies: 5
- Views: 4668
Re: view - no read access to elements
IF I create dynamic subsets and assign to a view, which reference elements based on certain criteria (MDX based), this shouldn't happen either right?
- Thu Sep 04, 2008 2:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: view - no read access to elements
- Replies: 5
- Views: 4668
view - no read access to elements
After re-loading all my dimension elements and loading my data the following error occurs when opening the cube. I have a feeling it is to do with a previously saved default view. However, does this mean all the default views created manually need to be recreated each time after the chores complete?
- Wed Sep 03, 2008 6:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Out Of Memory Error
- Replies: 4
- Views: 4956
Out Of Memory Error
Hi,
I was wondering if anyone has encountered the error where a Chore executes however at the completion of the chore an "out of memory" error appears. If anyone has encountered this before:
a) What are the causes?
b) How to rectify the issue?
Thanks in advance.
I was wondering if anyone has encountered the error where a Chore executes however at the completion of the chore an "out of memory" error appears. If anyone has encountered this before:
a) What are the causes?
b) How to rectify the issue?
Thanks in advance.
- Wed Aug 27, 2008 3:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Changing formula for consolidation to sum rows
- Replies: 11
- Views: 9286
Re: Changing formula for consolidation to sum rows
So if you take at a look at my first screenshot in this thread. Say I had another dimension called SKU. Say, there were two SKUs, 1 & 2. I want SKU 1 "daily avg" to be equal to the summation of consolidations: L1 D108233, L2 D108233, L3 D108333 but want SKU 2 "daily avg" to b...
- Tue Aug 26, 2008 6:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Changing formula for consolidation to sum rows
- Replies: 11
- Views: 9286
Re: Changing formula for consolidation to sum rows
What if the consolidatechildren had to work such that it consolidates different children or range of children depending on the SKU?
So for SKU1 it consolidates children 1..3, SKU2 it consolidates children 1..20. Can this be achieved with this function?
So for SKU1 it consolidates children 1..3, SKU2 it consolidates children 1..20. Can this be achieved with this function?
- Mon Aug 25, 2008 4:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Changing formula for consolidation to sum rows
- Replies: 11
- Views: 9286
Re: Changing formula for consolidation to sum rows
i guess I could create a separate two dimensional cube, SKU by MAXDATE. However, I think with what you've got there and together with some of the logic I have I've got the answer to keep it in the one cube. This cube is not going to be used for reporting or any analysis. It is just a staging cube to...
- Sun Aug 24, 2008 5:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Changing formula for consolidation to sum rows
- Replies: 11
- Views: 9286
Re: Changing formula for consolidation to sum rows
Hi Mike, I can't use datestamp or a hardcoded formula for this as the MAXDATE is different for each SKU. So in this cube there is another dimension, which determines the MAXDATE by SKU. Essentially, the MAXDATE is the last date in the range of days for which there was a sale. So I need a formula, wh...
- Sat Aug 23, 2008 2:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Changing formula for consolidation to sum rows
- Replies: 11
- Views: 9286
Re: Changing formula for consolidation to sum rows
How about if I wanted the intersections of ['top', 'maxdate'] and ['rollingdays', 'maxdate'] not to aggregate, however to be equal to the value of '108245', which represents a date timestamp. Any suggestions?
- Fri Aug 22, 2008 12:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Changing formula for consolidation to sum rows
- Replies: 11
- Views: 9286
Changing formula for consolidation to sum rows
Please see attached file. I have the following scenario where I calculate the daily average as 'Quantity\Level Number' at a 'C' level across all consolidations in the "Dim_Time4" dimension that begin with "L", (using a STET) however at the "Total Days" level I need the ...
- Tue Jul 15, 2008 9:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: sending data from a detail to consol cube with diff. dims
- Replies: 10
- Views: 7770
Re: sending data from a detail to consol cube with diff. dims
Hi Martin, The problem was that the values I was populating the Attribute, "Product Category" with were not the same as the consolidation name in the hierarchy. So TM1 was trying to do a lookup via the attribute value against the consol element in the Price Cube but both were not matching....
- Tue Jul 15, 2008 5:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: sending data from a detail to consol cube with diff. dims
- Replies: 10
- Views: 7770
Re: sending data from a detail to consol cube with diff. dims
I tried exactly that but the values are not coming through to Cube 2. So essentially I'm entering prices at a category level in Cube1 and wanting to see the price in Cube 2 flow down to each SKU pertaining to its category. I have an attribute against each sku giving the product category it belongs t...