fill empty cell

Remco Vos

Hello everybody,

 

I have a cube where I would like to be able to change amounts per customer per date. This functionality requires me to fill in certain fields from time to time, which are still empty. I have turned on split&splat and activated a partern based allocation on the cubes. As soon as I try to fill in an empty though, I encounter the following error message: 'A Data Entry on an empty cell isn't possible on a logical view'. I have no idea what it's talking about. Could somebody help me?

Dietmar Jeschkeit

Hi Remco Vos,

 

with a pattern based allocation you can´t use normal save (green sign or F9 or Procedure step save data entry). For saving pattern based you can only use the blue sign on the cell itself (or the procedure step save with pattern based…) (see Picture).

 

 

Hope this helps.

Dietmar

Remco Vos

Hello Dietmar Jeschkeit

 

Thank you for your help! Your remark definitely helped me. My issue evolved a bit though. I don't get those blue triangles on it, but I did manage to create a procedure with the step 'Save Data Entry using a pattern based allocation'. After running this procedure it notifies me with 'Data Entry Performed' in the popup. The data itself gets saved if it already had a value, but if it did not have a value yet (the entire reason I started using patern based allocation is to make that possible), it gets discarded. How can I make this work correctly?

 

Remco

Dietmar Jeschkeit

Hi Remco Vos,

 

maybe you can share some more Information (screenshots from your dataview e.g.). Just to be sure, your source cube has data on the cells you would like to have in your target cube ?

 

BR

Dietmar

Remco Vos

Hello Dietmar,

 

I have a cube with data in it regarding open invoices of customers. The cube has two dimensions, customer entity and time entities. It stores amounts to be received on those dimensions. I want to be able to move/divide the amounts to be received over to other periods, to eventually see the impact on cashflow. The data I manually fill in needs to be stored in a second cube (which is exactly the same as the first cube, but empty). Both of these blocks are invisible, and I show all data using an algorithm block (a+b) with a reverse algorithm (b=c-a) on it. The dataview uses the entity 'Customers' by row and 'Week' by Column.

 

When one of both cubes has data in the cell I change using data entry, the data entry succesfully gets stored. If I try to move the amount 1 period later, it still says data entry is performed succesfully, but all my data in those fields disappear again (a.k.a. do not get stored). What is going wrong here?

 

Thanks for your help!

 

Remco

Dietmar Jeschkeit

Hi Remco Vos,

 

if I understand you right you don´t need to use pattern based data entry. If your "Delta cube" (for storing the changes) is on customer and week it is on most detailed level and you can insert the values using normal data entry.

Here are my screenshots (Block "Original" and "Delta" can be hidden, here only shown for understanding):

Block a is Original, Block b Delta with data entry enabled and Block c is a+b with data entry enabled and reverse algorithm b=c-a:

Now I divide the 1756 in week 40:

 

All worked without pattern based (even if I hide Block a and b).

 

BR Dietmar

Remco Vos

Thank you Dietmar,

 

I had a second version of the cube where days were my most detailed level, which was apparently the blocking reason of it all (thought it would not matter that much, cause it would split and splat the results down anyway. I thought wrong). You have helped me a lot!