Why is there no Data in my Cell?

Introduction

Many Kepion users have encountered an empty form cell that should be filled and asked, "Why is there no data in my cell?" In this checklist, we will walk you through typical solutions to the problem, so you can quickly diagnose and fix it on your own.

 

Note: We strongly recommend you follow the checklist in order. 

 

 

Check Partition

The first diagnostic step is to verify that the data actually exists in your partition. 

 

1. Go to your target Model > Data > Rule or Writeback.

 

 

2. Review to ensure the desired data is in your partition:

 

• If the data is in your partition, choose one slice of data and use it for diagnostic purposes as you move on to the next checklist item. Make sure to note down the Dimension Members that lead to this value. 
• If the data is not in your partition, continue to step 3. 

 

 

3. Depending on the partition type, the solution differs: 

 

• For Writeback partitions, there's likely an input issue with your Form. Refer to this article for assistance. 
• For Rule partitions, check any View Data Rules to ensure the correctly configured the calculations. 
• For any additional partitions, verify any associated Action Data Rules and the general data integration process.

 

 

Check Form Layout and Filter Selections

If the data exists in the partition, you should check whether you've configured your Form correctly. 

 

1. Go to the Layout tab of your Form. 

2. Review that you have selected the proper hierarchies for Row, Column, and Filter. 

 

 

If your Form is in order, you might have made the wrong Filter selections. For example, referring to the data partition shown in the previous section, we have not inserted any data into the Forecast scenario, only the Plan scenario.

 

So when we have the Filter set to Forecast, the Form is empty:

 

 

Simply changing the Filter selection to Plan displays your target cells and data. 

 

 

We recommend you double-check your Filter selections before you input the data. If not, you might input your data in the wrong cells. You could have the proper Filter selections, but the cells would be empty. 

 

 

Check Cell Details

If you have the correct Form configuration and selected the right Filters, but your data still isn't appearing, we recommend checking the cell details. View cell details by going to your Form, right-clicking the cell, and selecting Cell Details. 

 

 

You should see the following window: 

 

 

Slice 

1. Scroll down to the Slice information. 

 

 

2. Verify the MemberIds in the Slice information match the Members on the Form and in the partition:

 

• If they all match, move on to the next checklist item. 
• If they do not, the wrong cell has likely been targeted. Check the Row/Column/Filter layout and selections to see if you're working with the correct cells. 

 

Is Input 

You might not be able to post data to your cell because it's not 'inputtable.' The Is Input value would be FALSE in this case. 

 

 

Refer to our Cell isn't 'Inputtable' or Annotatable article for a comprehensive guide on making your cell inputtable. 

 

Is Annotate

If the Is Annotate value is TRUE, the cell will be querying the Comment column of your table, not the Value column. 

 

1. Go to your target Member List(s). 

 

 

2. For any Members used in your target cell(s), uncheck their corresponding box in the Annotate column 

 

 

 

 

Check Cell Attributes

If Cell Attributes have been set up for the Form, they could override your target cells' default properties. 

 

1. In the Form Editor, right-click the cell and select Manage Cell Attributes.

 

 

2. Click Edit to verify an attributes configuration. 

 

Note: If you don't see any Cell Attributes, the issue is likely addressed by a different checklist item. 

 

 

3. Check the Attributes and Format tabs for input overrides or special formatting.

 

For instance, if you have aggregate values in your cell, you might have selected the Hide aggregate values option in the Attributes tab. 

 

 

Alternatively, the cell might have custom formatting (e.g., white font) that makes it seem like there's no data:

 

 

When you look at the ribbon, the text color set for the cell is black. Always verify if custom formatting is overriding the ribbon selections. 

 

 

 

Check Custom MDX

Your target data may not flow through if you have used any custom MDX in the Form, Model, or Member List. We recommend first identifying and disabling all the MDX used on your Form and then testing each instance individually.  

 

Form Native MDX

1. In your Form, go to Advanced > Native MDX. 

2. Disable custom MDX by unchecking the boxes next to With, Column, and Row. Select the boxes to enable the MDX.  

 

 

Model Rules

1. In the Model that contains your Form, select Rules.

 

 

2. Under the Active column, uncheck the box that corresponds to your MDX Rule to disable it. Click the box to enable the Rule. 

 

 

3. Double-click your MDX Rule to review the query. 

 

 

Dimension Member Formulas

1. Go to a Member List used in your Form. 

 

 

2. Go to the Calculate tab and select the for your formula(s)

 

 

3. Copy your formula(s) and paste them into an easily accessible, secure place. 

 

 

4. Delete all the formula definition(s) and bring them back one by one for individual testing.