Hello, I am new to WebFOCUS. We are rolling out version 7.7.02 and have some questions around best practices.

We’re interested in rolling out 1 big Sales Business View, pulling from our dimensional data warehouse.

We think that we'll have to build summary sql views in our DB, so that users don't get misleading results in WF Infoassist when pulling data from Business Views that join Master Files with different levels of grain (ex. sales order line(one ordered qty row with a qty of 1) & sales order deliveries (many qty rows)) I guess the question is, how do we get the sales order line qty field to stop repeating automatically for every delivery row in InfoAssist without using two reports ?

We know we can write reports to deal with this, but would rather put it in the Business View feeding InfoAssist. We want to turn the Business Views over to the power users and make it very easy for them to run reports across several subject areas (Sales Order Lines and Deliveries for example) within one Sales Business View.

We think we may be missing something

I apologize if I’m asking this question incorrectly. I am new to WF!

This message has been edited. Last edited by: egghead,

7702 has introduced metadata based sub-selects. One of the major benefits that I can see is the ability to incorporate conditional facts and measures from multiple sources under the same view. It allows you to do things like context sensitive distinct counts and any summary based calculation on the fly and avoid data replication that can happen when you are trying to merge different tables at different granularity levels. Open a case with CSS to get the doc on this feature.

Good luck

Thank you dhagen! One of our developers opened a case but the tech does not know about this feature or document. Any suggestions?

Ask them for page 2 and 12-14 of the January 2011 Tech Insider.