Data Drill not showing all records

Unknown
Unknown
edited October 2020 in Platform
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
------------------------------

Answers

  • Sebastian Gurt
    Sebastian Gurt Employee
    Fourth Anniversary 100 Likes 10 Comments 25 Up Votes
    edited November 2020
    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
    ------------------------------
    -------------------------------------------

Categories