Essbase

Get Involved. Join the Conversation.

Topic

    Arcanus Prime
    Method to find intersection with actual data in Essbase with...
    Topic posted June 10, 2019 by Arcanus PrimeGreen Ribbon: 100+ Points, tagged Essbase, OAC Enterprise Edition, Smart View 
    60 Views, 2 Comments
    Title:
    Method to find intersection with actual data in Essbase with SmartView
    Summary:
    I'm trying to find a simple way of targeting an intersection where there is non-missing, non-zero data.
    Content:

    Hello Oracle Essbase World,

    I have a fairly simple question regarding SmartView and Essbase.  It's on the cloud, but that isn't relevant for this question.  What is the easiest way to find an intersection with actual non-missing, non-zero data?  I have heard there are VBS scripts that can do that, but is there a simpler way?  If not, what is the best method to be able to jump to an intersection where this exists?  

    Thanks!

    Comment

     

    • Ashish Jain

      Smart View provides a way to suppress #Missing data cells

      On the Smar View ribbon, click Options and then select Data Options.

      Under the Suppress row -> check No Data / Missing or Zero, as required.

    • Tim Faitsch

      Some cubes have a design that makes it almost impossible to find data. In that case you can run a database export to see where the data resides. That's more of an exercise for an administrator. Good cube design will make it easy for users to find data.