Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best Way For Creating Specific Fact (Non-Standard Aggregation)

679874Apr 21 2016 — edited Apr 21 2016

Hi All,

Question about the best way to create Margin of Error as a fact?

Originally I had created a new logical column off of a database fact for Margin of Error by selecting Derived from existing columns using expression and then the calculation: 1.96(STDDEV(FACT COLUMN)) /  (sqrt(COUNT(FACT COLUMN)))/ Which works mostly fine. The only difference I can tell is that I can't use the column filter function like I can if I use Derived from physical mappings. But besides that the data recalculates correctly if I add new columns to the report.

But that is my question, should I use the option Derived from physical mappings instead and if so, how do I make it work? I got the calculation to work, but I left the aggregation as None. When I tried out the new column in Answers, the value that is returned is correct for all the data, but if I add any other columns, the data remains the same. So it doesn't recalc like it does with using Derived from physical mappings.

Any thoughts on how I should be doing this, am I doing it right?

Thanks all for any advice.

Comments

Marc Sewtz-Oracle

Hi - I have not heard of performance issues with tabular forms using IE before. Is this just a plain, standard, wizard-generated tabular form? Perhaps you could re-create a tabular form page that has these issues in a workspace on apex.oracle.com and point me to that example, so I can take a close look at what might be causing this?

Thanks,

Marc

Turlock22

Hi Marc

Thanks for coming back, I tried to recreate the issue on apex.oracle.com but the issue won't replicate in 5.1, my current version is 5.0.4, is there a version of that available for testing?

Yeah the issue is with a completely bog standard MRU table, so I get a hundred row table with about 10 columns (although really doesn't need that many rows at all), include all columns for updating and as I scroll through the page the browser slows down to bits.

It only happens when I scroll over the MRU table, so further down the table there's charts etc, once the MRU's are off the screen everything speeds right up

Hard to show it without a demo, I'll look into upgrading to 5.1 but that probably won't be for a while

Turlock22

Oh and just to confirm I've installed Fiddler to monitor web traffic and when it's going slow there's no traffic going up and down, so it literally just seems to be a rendering issue with the screen in IE, very odd :/

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 19 2016
Added on Apr 21 2016
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
0 comments
294 views