Forum Discussion

Davy's avatar
Davy
Contributor
3 years ago

Cubes in Essbase vs 1Stream

Happy inflation and food shortages <Not!!> Quick question. I have over 15 years experience in Essbase and find it confusing that we have multiple 1Stream cubes in one 1Stream application - but they ...
Cubes
  • ChristianW's avatar
    ChristianW
    3 years ago

    1) One workflow controls/updates one Toplevel Cube and its descendants. An embedded cubeview can be used to input data in multiple, none related cubes, but these cube's input isn't controlled by the workflow (e.g. out of the box you can't lock it within the workflow).

    2) You can always look at a Cell's pov:

    to get the cube information

    If you like, you can use the name command to add the cube name to a row or column header: |CVCube| but typical we don't like the end users to get confused by cube.

    3) No 'Clubs Parent Adj' is using the Golfstream cube and it uses the same cube like Frankfurt, but Houston has its own cube, but it is an extended cube of Golfstream. But all cubes are related to Golfstream.

    4) No Parent id just the gender neutral version of father or mother.

Davy's avatar
Davy
Contributor
3 years ago

Thanks again Christian,

Before I award you "the solution", may I ask my questions again?

1) You wrote:
"Cubes are very close linked to workflows, in fact, Cubes are the top node of a workflow tree....
 One workflow is sharing either the same cube, or using extended children cubes (linked in Cube References). "

So  are you saying that ONE workflow can update different cubes?  For example, one workflow can have many CubeViews - each of which can  updates different cubes.

2) You wrote:

"the information about the top level cube is only 1 click away:"

Well, if a workflow can have multiple cubeviews that update multiple cubes, you statement is not true.

I would like to recommend that OneStream deverlopers put name of cube for each channel under a workflow .

In other words, a Workflow can have multiple children (aka channels), each of which have their respective cube - it is a pain to click each channel to see what cubes they update.  Please give my suggestion to your developers.

3) In your screen shot, is  "Clubs Parent Adj" is a parent cube to Frankurt , Houston and Eagle drivers?

4)  "US Clubs Parent adj" also a parent - a husband and wife pair? 1 parents!!??