Creating a cube with control dimensions

[yingchai]

I am planning to create a cube using the following dimensions:

- }ApplicationEntries
- Dim1
- Dim2

Is there any implications if creating a cube with control dimensions?

Thanks.

[lotsaram]

I am planning to create a cube using the following dimensions:

- }ApplicationEntries
- Dim1
- Dim2

Is there any implications if creating a cube with control dimensions?

Thanks.

It depends on the cube use. Be aware that all element weights in }ApplicationEntries are 0 so you won't be able to report any data at any consolidation or "folder" level. For this reason it's normally better to use a copy dimension with standard element weights of 1.

Issues in general with control dimensions are that they don't contain consolidations which can be helpful for grouping, calculations and reporting. Also for cubes and dimensions the dimensions are rebuilt from scratch on every server restart from reading the .cub and .dim files so any static subsets will lose all members (why this doesn't happen for chores and processes I don't know)

[mvaspal]

Hi
They usually contain S: elements, so maybe better to place it as the last dim in the cube (not necessarily) but otherwise you can use it in cubes.
There was a post earlier here on the forum, don't remember when , that was about issues with creating subsets from control dimensions but I might be wrong.

Anyway, I often use cubes with }Groups or }Clients included without any issues

[BariAbdul]

One more thing to consider is,there might be slight chance of someone confusing it with system control cube and inadvertently deleting it. Thanks

[lotsaram]

One more thing to consider is,there might be slight chance of someone confusing it with system control cube and inadvertently deleting it. Thanks

Can you please explain what on earth you mean by this?
(especially as given objects starting with curly brace can't be deleted via the UI, which makes "inadvertent deletion" somewhat difficult).

[David Usherwood]

And...
'someone' would have to be member of Admin (or DataAdmin) to delete the cube.

[BariAbdul]

Can you please explain what on earth you mean by this?
(especially as given objects starting with curly brace can't be deleted via the UI, which makes "inadvertent deletion" somewhat difficult).

Thanks,lotsaram.I don't know what I was thinking ,All I wanted to say this could be deleted by some other developer by TI out of confusion.
vCube= '}ClientSettings';

CubeDestroy(vCube);
I am sorry it is quite warm summer here

[lotsaram]

I am sorry it is quite warm summer here

Quite right. I'm sure it addles the brain.