Blank Cell with History

MarkTurkenburg
Occasional Contributor

Blank Cell with History

Hi Team,

 

I have a situation where some cells have had data entered to them & this is proved by the cell history but the cell is BLANK. I am struggling to understand why the cell history is not reconciling to the data in the cell. Please see the attached screenshots for an example but effectively I was expecting the value to be 'May 21' as this is the last entry in the cell history

 

Has anyone encountered this before & have a solution?

 

Thanks!

 

Mark

26 REPLIES 26
LipChean_Soh
Certified Master Anaplanner

Re: Blank Cell with History

Hi @MarkTurkenburg 

 

Let's try to work this problem out.

 

From your first screen shot, it seems that the cell is blank. I could think of 3 possibilities:

1. Your history isn't extensive enough, since it seems to cover till 26May. Can you try to do a 'All' history?

2. Could it be DCA that's preventing you from seeing the value in the module?

3. Did you select a parent level member in the page selector which might result in a blank cell in the module?

 

Thanks,

LipChean

MarkTurkenburg
Occasional Contributor

Re: Blank Cell with History

Hi @LipChean_Soh 

 

Thanks for the quick reply

 

To answer your questions:

 

1) I selected ALL History & it returns the same results

2) There is no DCA on this line item

3) No this is a list formatted line item & in the view I sent I can adjust the value as the end user could

 

Our Anaplan consultant partners are going to raise this with Anaplan as a product error but I have been using the software for 4 years & never seen this occur before

 

It is effectively not accounting for data entered into the system

 

Mark

 

 

LipChean_Soh
Certified Master Anaplanner

Re: Blank Cell with History

Hi @MarkTurkenburg 

 

Another possibility is due to someone restoring the model to a point where the cell is blank.

You won't see the <model successfully restored to change abcd> if you perform a history search on a specific module or cell.

You'll need to go to Admin page to do the full history check.

 

Thanks,

LipChean

MarkTurkenburg
Occasional Contributor

Re: Blank Cell with History

Hi @LipChean_Soh 

 

Yes that's what I thought but I am the only person to do a restore in the past week & that was purely restoring to undo a previous line item change (see attached history) & therefore it would not of changed any data entered

 

Thanks

 

Mark

LipChean_Soh
Certified Master Anaplanner

Re: Blank Cell with History

Hi @MarkTurkenburg 

 

Another possibility is the shifting of Model Calendar.

 

Thanks,

LipChean

MarkTurkenburg
Occasional Contributor

Re: Blank Cell with History

Hi @LipChean_Soh 

 

No that did not occur, it is a very strange situation

 

I have a meeting with Anaplan this afternoon to discuss & will post the result here

 

Thanks for your help

 

Mark

LipChean_Soh
Certified Master Anaplanner

Re: Blank Cell with History

Hi @MarkTurkenburg 

 

No problem, please keep us updated on this.

This is a weird and concerning occurrence, since it seems to imply there's a problem with the audit or worse, data can disappear from the database.

 

Thanks,

LipChean

tingtingxia
Contributor

Re: Blank Cell with History

Hi Mark

 

Yes, please update the topic here whenever you have some findings.

@LipChean_Soh it has been very informative reading through your trouble shooting thread on this topic as well. Really appreciate it. 👍

 

BR,

Tingting

LipChean_Soh
Certified Master Anaplanner

Re: Blank Cell with History

No worries @tingtingxia