Applied dimensionality

Difference between layouts is obvious:1 View-only is akward, old and slow (no dimensions for publish, blobs for value storing etc) 2 Table-only is modern, smooth and fast (dimensions, option to specify data types for publish and more) But I just cannot understand why annotation_user table is created only in View-Only mode. This table contains precious [...]

Can you imagine such a Contributor Application: 2 Cubes (A&B for example), each linked to each other so that when you input a value in a cube A cell, corresponding cube B cell changes to that value, and when you input some value into that cube B cell (the very same changed), cube A cell [...]

Use Directory servers in production! — that’s the conclusion One of a recent client’s complaints was slow Contrbutor login (to application list, to nodes tree). After doing all the bandwidth\performance checks, I’ve writen a small script testing timing of planning02.asp loading and found out that the bottleneck was user authentification, taking up to 20 seconds. [...]

I’m just pointing it out again — @Transform is a wonderful BiF, allowing to calculate trigonometric functions, exponentials and logs. If only we’d use them often.

Nowadays Cognos EP system should look like a set of Contributor Applications exchanging data. That’s an axiom, refer to Cognos Since we have these numerous apps, we need to transfer data between them. And we got 2 variants: 1 Get Data extension — a very nice feature (especially with system links) allowing us to locally [...]

After examining Palo source code to see how their “Splashing” works, I got interested in the rules of break-back in Cognos EP. Not satisfied with vague description in Analyst User Guide and performing some test and calculations, I’ve received following results. Break-Back calculates only on Sum\Substract\Multiply\Division, not on IF-ELSE, or BIFs. Here are formulas for [...]

Remember me whining about absence of allocation cubes with elist in Contributor? Well, I kinda remembered the trivial solution. I wanted dynamic profiling of expenses, for example. Like profiling Year Summs on Linear driver, 4 4 5 or smth like that. And this choice should be done by user “on flight”, in the application. Like [...]

One of the main things I carried out of my alma-mater is passion for data. When you’ve got data, so many interesting things can be done . Various analysis, comparison, stats – just givе the data. That was a rather pathetic preambula. Let’s get straight to business. Problem. On recent project I was doing some [...]

Having problems with your dllhost.exe grabing a huge amount of RAM and going into winter sleep? A real hog he is, that dllhost.exe. CenterStone pointed on Cognoise, that COM+ memory leaking is an accepted Planning bug, and is resolved in 8.1.Well, I didn’t know that, so had to deal with this problem in 7.3 SP3. [...]

After making “Send Data” macro via ASP we’ve logically stepped on the problem of restricting this macro usage. Logically thinking this macro should be executed only after all data is entered in application (in other variants, data recipients will never be sure that they have the latest variant possible). That’s what I call coordinator problem [...]