In Smartview 126.96.36.199.300, we have noticed that if we exclude attribute dimensions from our report, then we are able to drill down to Bottom level on all our reports; but if there are attribute dimensions listed, then it throws errors. Is it an option to drill down to bottom level, while keeping the attribute dimensions in the report? Thanks.
Edited by: 937685 on Jan 17, 2013 9:35 AM
It would be helpful if you said what the error was but I'm guessing it's timing out? Either way the thing you need to remember with attributes is that they are dynamically calculated and depending on the design can impact performance hugely.
The quick answer would be to use the 'Navigate without data' option in SV, which strictly speaking you should be doing anyway or any deep zooms. Then refresh with the option off and see how it fares.
According to Oracle that still relates to a timeout error: SmartView Error "XML Load Error: DTD is prohibited [ID 1059964.1]
Update the registry on the client machine with the following settings:
You may need to reboot, I've seen it make a difference without the need.
Is this an FDM connection?
Anyway try that.