Comments

  • 1-3 of 3
  • Greg

    The only way around this for me was to leave out a dimension from both the grid and filter. For me this is not a viable solution since I report off of an Essbase cube and need to be able to filter on every dimension. I spoke to the Oracle Dev guys and they say that they are working on a patch fix which will become available soon. I'm not sure what "soon" means since I've had a ticket open with them for over 5 months now. 

  • Greg

    Try removing the filter and changing the actual column expression to something like ...

    Case when (EOAWUSER_TYPE = 'R' then 'R')
    else ' ' end

    The report shouldn't blow up since it pulls all data. Only the "R"s will show. Might not be perfect but thats all I can think of.

    Good Luck!

  • Greg

    Hi SM,

    You basically have to choose to have the data indexed for it to show up in Day by Day. In DV go to Console, then go to Search Index. Find the data model you want to show up in Day by Day and change the "Crawl Status" to Index. Change the Scheduler to run every hour. Check Day by Day in an hour and type in or say a dimension and see if it shows up.  Also, in my experience I have found that Day by Day works best with a relational database rather then a multi-dimensional. 

    Good Luck!

    G