Best Of

Dear Peter van Bennekom,

thanks for your request. In General populating figures inside a ROLAP Cube ist exactly the same as for MOLAP.

Belonging your questions.

1. How do I open the cube so i can set values for ALL members? It is not doing this. When I had a "normal" cube (not rolap) it put values in all members - not so for rolap cubes. 

         ==> When we talk about DataFlow this is each time running in the active selection of your procedure. Means when          you don´t have selections the DataFlow is working for the whole Database. When your ROLAP Cube don´t find          any Data after the DataFlow, please check the SQL Log. (see attached Picture). Mostly it is Problem due to date               conversion. 2. How do I save this cube (without saving the whole database)? In the screen I can click the green toggle save widget but I have not found the equivalent in the procedure steps.

==> you don´t have to save the Change populated by dataflow separately. This is done for free when the dataflow ended.

Hope it helps.

regards

Alexander Kappes

Hi Adriana Mitillo, Hi Helmut Heimann,

the idea with Nexel is working, I implemented in other Projects with success.

But I also used 2 DataViews, one for the top 3 and another one, which uses Nexel Gross View to subtract the TOP3 from the Total of all dimensions.

Hope it helps

regards

Alex

Dear Emanuela Dolce,

this is only possible using procedure and Export Layout Procedure Step.

This step allows you to define your extract file according to a DataView.

Means you have to define the row Entity, which should be the one where you Need the biggest value of.

Finally you filter your cube for the biggest value.

The extracted File can be reloaded into another cube e.g. by using ASCII Reader.

But using this Suggestion you have to take care, that you extract a file according to one Dimension. When you Need other structure in your target cube you have to build up process to implement the figure into this.

Depending to the Detail case perhaps nexel can also be working solution for your

regards

Alexander Kappes

Dear Selvet Yönsel,

thanks for your request.

Starting from BOARD 10.1 Procedure Change log has been implemented and can be activated, like the attached Screenshot explains.

Hope it helps.

regards

Alexander Kappes

Dear Wahyu Nugraha,

thanks for your request.

To solve it, easiest way will be Nexel.

In my little sample I inserted normal Text Column Algorithm inside my Layout with syntax "today()".

Based to this I calculate the Month and Week within Nexel with the Syntax shown in the Screenshot.

Hope it helps.

regards

Alexander Kappes

Dear Wahyu Nugraha,

thanks for your request.

For general, when you calculate the differences between Cubes, the calculation is based to the Dimensions the cube is belonging to.

For your Case a DataFlow "FC-Admin" - "Choose Year" will bring the result -1 for 2017 and 1 for 2018 because each year is calculated separately.

Perhaps our E- Learning portal helps you to understand how BOARD is working.

regards

Alexander Kappes

Dear Marcel Bila,

just perform a double click on the deepest Column Entity to execute your procedure or drill.

You are right, that the well known icon from the win client isn´t visible anymore but the action, when you double click on the entity is the same.

Hope it helps

regards

Alexander Kappes