TM1 Forum

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

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.

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.

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

samy2 wrote:IN need of a BA with OLAP TM1 ESSbase and Microsoft Analystics for Local Houston fulltime opportunity with Energy Company.

Hi,
Please provide me details of the job description and an email address where I can submit to you my CV.

Unfortunately, still no luck with this. I tried putting the attribute "prod_cat" on the prod dimension as well.

HMMM.

That didn't work either. hmm really puzzling me now.

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.

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

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?

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?

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.

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

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?

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

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

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?

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

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

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