Data Drill not showing all records

Question

Hi Guys,

I'm wondering if anyone has come across this issue I'm having. Board is loading data in fine via the data reader, however we have several finance reports that show the correct numbers at high level in the data tables, however when we drill into the lines there are no records for the current month at the transactional level, only prior months. High level numbers in the tables still show the correct value however.

Has anyone come across the same issue and if so how do I fix?

Many thanks,

John

------------------------------
John Kenton

United Kingdom
------------------------------

Sebastian Gurt · Answer

Hi @John Kenton,

this kind of behaviour is usually related to missing relationships.* Please check your hierarchies for missing child/parent relationships.
* When using cube versions make sure these are all aligned (might need to add align step in your calculation procedure)* If your version show different checksums it could again be a problem with your relationships

* another thing that sometimes happens: If you have a filter applied to your layout, the filter will also be applied to the drill down layout but migh lead to unwanted results.

Hope this helps

BR

Sebastian

------------------------------
Sebastian Gurt 
Consultant Team Leader
Board International
Germany
------------------------------
-------------------------------------------