Log in to create and rate content, and to follow, bookmark, and share content with other members. Not a member? Join Now!

AnsweredAssumed Answered

fill empty cell

Question asked by rvos on Oct 16, 2019
Latest reply on Oct 21, 2019 by rvos

Like • Show 0 Likes0
Comment • 6

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?

No one else has this question

Outcomes

6 Replies

djeschkeit Oct 17, 2019 5:31 PM
Mark Correct
Correct Answer
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
1 person found this helpful
Like • Show 1 Like1
Actions
- rvos @ djeschkeit on Oct 18, 2019 12:35 PM
  Mark Correct
  Correct Answer
  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
  Like • Show 0 Likes0
  Actions
  - djeschkeit @ rvos on Oct 21, 2019 11:58 AM
    Mark Correct
    Correct Answer
    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
    Like • Show 0 Likes0
    Actions
    - rvos @ djeschkeit on Oct 21, 2019 1:49 PM
      Mark Correct
      Correct Answer
      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
      Like • Show 0 Likes0
      Actions
      - djeschkeit @ rvos on Oct 21, 2019 2:19 PM
        Mark Correct
        Correct Answer
        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
        1 person found this helpful
        Like • Show 1 Like1
        Actions
        rvos @ djeschkeit on Oct 21, 2019 2:50 PM
        Mark Correct
        Correct Answer
        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!
        Like • Show 0 Likes0
        Actions

fill empty cell

Outcomes

Related Content

Recommended Content

Contact BOARD

Discover BOARDVille

Follow us