Context Related Question

[smooveb]

Hi,

I have a field in one report, every time I add this field I automatically get another select statement in my SQL. I realize this is from the different context being used in my Universe.

However, I do not understand why this different context exists in my universe. When I look at everything, there seems to be no need for the extra context. There is only one way to go for any particular piece of data.

Can any experts out there help me identify possibilities, whether they deal with the universe or the database itself? Would be greatly appreciated!

Barrett

 

[blom0344]

Even if a universe is straightforward enough (simple starschema, for instance) not to need contexts, one can still technically impose a context on some of the tables. So, in your case check if such a context exists and if so, verify that it is unneeded. Get rid of the context on your developing -machine and check everyhing before exporting it to repository.

T. Blom
Information analyst
tbl@shimano-eu.com

 

[skrandel]

Don't forget about "poor-man's contexts".

If you retrieve measures (real measures) from multiple tables, BO will break the query into multiple SQL statements. A real measure is one that has SQL aggregation on it. e.g. sum(table.column).

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

skrandel@baseconsulting.com