Smartview taking long time to retreive data from BSO cube — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Smartview taking long time to retreive data from BSO cube

in Oracle Guided Learning 2 comments

Smartview taking long time to retreive data from BSO cube. We started facing this issue 3 months ago. Also did below setting change but no help

  1. in Formatting: Select the option to Use Excel Formatting.
  2. in Advance -> Compatibility: Select the option Improve Metadata Storage
  3. In Data Options: Select Suppress No Data/Missing, Zero
  4. In Excel -> Tools -> Save tab, disable the 'Save Auto-recover info every' which can have a negative impact on large queries that take time to render.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!