TM1 Forum

Hello, Platform: Cognos Express 10.2.1 I've got a TM1 cube with 3 dimensions: Time, Client, Measure. I'm doing a report in report studio based on this cube, and have some issues with measure aggregation. In my cube, there are 2 measure types: aggregation by total'ing ("profit, USD"), and a...

Hello everyone, thank you for your replies and contributions. Changing aggregation weights will not solve my problem, since user cannot change the weights - only developer/administrator can edit the dimension. Also, as tomok said, it'll break the original hierarchy. Michel, I really liked your sugge...

Hi, my client wants to aggregate specifically selected elements from hierarchy. Example hierarchy: -ItemGroup1 --Item A --Item B --Item C --Item D -ItemGroup2 --Item E --Item F My client wants to select ItemGroup1, ItemA, Item B, ItemGroup2, Item E, and expects to see this (text in italics is my com...

Steve Rowe wrote:All seems a bit odd for a 64 bit box...
How much RAM have you got free before you save the rule? 2-3 minutes is very quick for RAM to run out even if something is wrong.
Can't really offer much more with the information to hand.

I have ~8-9GB RAM free before saving a rule.

The rules point to different measures. I think you need to expand on the reason for this. 'TMP Pirkimo poreikis' was created as an intermediate measure just to hold values of DB('atsargos', !Inventory, !Laikotarpiai, 'Mato vnt', !Sandėlis-tranzitas, !Planas-faktas, 'Poreikis pirkti'); and participa...

Hello, I've wrote 2 ways to calculate a measure and feed it. Way #1 eats all available RAM and crashes, way #2 works flawlessly (minor increase in RAM). Any idea why #2 works and what's causing it? WAY #1: Source (cube 'atsargos'): FEEDERS; ['Mato vnt','Poreikis pirkti'] => DB('salygos', !Inventory,...

I've put my nightly data load in multiple separate processes, then created a master chore and put all processes inside. This way, if an intermediate process fails chore continues to execute other processes. The only problem is I can't write comments in chore so all data load logic is not that clear ...

I have a nightly load process, which runs various other processes using ExecuteProcess(); problem is, if any of processes fail, it stops working and does not execute other processes. My nightly load process example: ExecuteProcess ('export_klientu_planavimas_SQL'); ODBCOpen('cogsql2005', 'cognos', '...

Are you trying to sum the actual value on the years or are you summing the average (that would be interesting)? Does that actually work for you? Hello, for a year, I'm summing averaged values of each month. I've talked with my client and I managed to convince him he needs only 7 aggregated measures...

That is a very nice example Tomok, thank you

Hello, I have a cube with multiple dimensions ('Time', 'Measures', and others) and for specific measures I want to consolidate to average (instead of sum) on all dimensions except 'time'. For example, my 'clients' dimension has 3 levels - country > city > klient; my time dimension has 2 levels - yea...

No, but I need this measure as an intermediate step to calculate another measure, which needs to consolidate. In which case you do not need to feed this intermediate measure at all. You just need to feed the final measure. Ok, I did some testing and that's what I found out ('dummy' measure is fille...

No, but I need this measure as an intermediate step to calculate another measure, which needs to consolidate. In which case you do not need to feed this intermediate measure at all. You just need to feed the final measure. Ok, I did some testing and that's what I found out ('dummy' measure is fille...

qml wrote:Do you need values calculated by this rule to consolidate?

No, but I need this measure as an intermediate step to calculate another measure, which needs to consolidate. Feeding the top elements would be a good idea though - I should give it a try.

Hello, sorry for a late reply and thank you everyone for your ideas and contributions to my problem. I've solved my filling problem by creating a view as a source (selected only my 'dummy' measure and unchecked "skip zero/blank values"), then created a numeric variable (formula: variable =...

Hello, I want to fill a specific measure in cube with 1's. I can do this with rule ['My measure'] = N: 1; however, this rule will not work with feeders. I can fill 1's with spreading (data spread > repeat leaves), but I don't want to do this manually every time when I zero out cube before loading da...

Re problem #1: Let me start by saying that what you are doing with this looks very weird to me. Can you tell us why you need to populate so many nodes in this cube with what is effectively a set of constants? Secondly, why do you need a feeder in the first place? Consolidating numbers of days seems...

Hello, problem #1: Rule: ['Viso dienų skaičius per mėnesį' ] = N: ATTRN('Laikotarpiai', !Laikotarpiai, 'Dienų sk.'); (rules takes attribute "Dienų sk." (number of days on month) from time dimension) Feeder: ['2010.01'] =>['Viso dienų skaičius per mėnesį' ]; Problem: feedprob2.gif for some ...

I've optimized dimensions order (gain was -90%), but opening time stayed basically the same. ViewConstruct seems to have helped (but I'll keep checking for a next few days to make sure views open instantly).

Thank you everyone for your input.

I wrote: "If I open a cube in other TM1 tool, opening takes long time again. For example, if I open it in Perspectives, it takes 5mins for the first opening. After that, if I open it in Web Contributor, it takes 5mins again." Please disregard this - in contributor, I was opening another vi...