TM1 Forum

Hi Alan,

we have not been storing individual actual salaries up to this point but clearly it's more efficient to do so, so that's what I'll do.

Thankyou for your help.

cheers,

Gregory

Alan,

of course, if the Salaries were all multiples of $5,000 as in your example, we could use simple alternate hierarchies. Unfortunately they are not, there are thousands of discrete individual salaries.

cheers,

Gregory

Hi Alan (& others), Thankyou for your analysis. You would then have two hierarchies of consolidations, each of which consolidates all of the salary elements which fall into that particular band. I'm not aware of a way that TM1 can consolidate into "Bands". If it can, I would be very in...

Hi Alan,

certainly a single hiearchy would work if that was the case, but alas, no, they are different Types of awards and each individual needs to be classified according to Each Type. Hence they both start at $8000 but the banding is different.

cheers,

Gregory

Hi Lotsaram,

each hierarchy has unique base elements e.g.

Hierarchy 1, Elements; "$8000-$36000", "$36000-$48000" etc.
Hierarchy 2, Elements; "$8000-$34500", "$34500-$45000" etc.

as they are based on different Salary Award scales.

cheers,

Gregory

Perhaps I didn't make the question clear enough. What I am considering is the relative cost in populated cells & memory usage between 2 design alternatives; 1. An employee cube with 2 different Salary Band dimensions and 2. The same cube but only 1 Salary Band dimension instead of 2, and with 2 ...

Lets say we have an Employee Details cube with 100,000 employees and 2 salary band dimensions (2 different types of salary bands) and say 10 measures. The number of cells is 100,000 * 10 = 1,000,000. Now lets say we replace the 2 salary band dimensions with 1, with 2 hierarchies. The number of cells...

Yes, sorry, when I thought about it some more the calculation is 400,000 x 39 x 5.

Thanks,

Gregory

We have a cube which is populated with approx 400,000 records every year. There are 18 dimensions and a measures dimension. Cellputn's are done for each of the 39 measures. With 5 years of data I would have thought the Number of Populated Numeric Cells would be; 400,000 x 18 x 39 x 5 = 1,053,000,000...

Hi Lotsaram, Thankyou for your response. the dynamic subset is a very simple Level 0 on a 16 Element dimension. The fact that the speed is fine when outputting to ascii rather than than doing a cellputn suggests to me it's a bug. I believe there is also some other environment or external factor invo...

i had a similar issue; http://forums.olapforums.com/viewtopic. ... 520#p12520

OK I've found the problem and it appears to be a bug . :o It seems that if you refer to a dynamic subset in the data tab you will get the "Completing Display procedure of process" message in the "Process Progress Report" and the process (if it is doing any cellputn's) will run mu...

John - sorry I should have mentioned that logging is turned off in the prolog. I've even "turned it off at the wall" (Cube->Security) to be sure. The view is built in the Prolog - the fact that the Asciioutput is fast suggests to me that there is nothing untoward with the view. Steve - the...

I have a similar issue to http://forums.olapforums.com/viewtopic.php?f=3&t=2695 . We have an allocation process, based on a view, which takes nearly 5 hours to read approx 1 million records and write a slightly larger number. "Way too slow" I thought, (our main load processes from .csv...

Did a deinstall/reinstall of Perspectives => no change.
Did a deinstall/reinstall & this time included Architect in the install => now it works.
?

Hi,

anyone have an update on this issue? Our Server is 9.4.1 FP2, client is 9.4.1 & the Server -> View Transaction Log function doesn't work.

thanks,

Gregory

I've tried the ReevaluateConditionalFeeders = T & it didn't make any difference.

Any other ideas?

Cheers,

Gregory

Hi Gregor, I don't think it will work either as the Feeders for Cube C are not conditional. The only hope is that somehow the implementation of the function works to resolve dependencies. Never forget the option of feeding from within cube C which I think I tried to explain to you on your last Feede...

Thankyou Gregor, Steve & Kielmc for your considered advice. I've responded to each of you below; Under the Assumption that Cube C is called 'Month P&L'...and Cube A is not called 'Voyage Profile'. Sorry Gregor et al, I omitted to change the Cube Names in the Feeder - have now done this. Cube...

Hi All, I need some help please... In our model we have 3 cubes; Cube B feeds into Cube C and the rule in Cube C is based on matching the Month and Year from Cube A. This is the rule in Cube C (which has 15 dimensions); [{ 'Scenario 1', 'Scenario 2', 'Working Weekly', 'Weekly Adjustment'}, '40710'] ...