The cube build process does submit Prepare statements that do a "select *" on each dimension table, in order to get the table headers, but it does not execute those statements.
In your typical cube build, if you run with
OPTIONS SASTRACE=',,,ds' sastraceloc=saslog nostsuffix;
you'll see something like that:
ORACLE_61: Prepared: on connection 1
SELECT * FROM "OLAPTST1"."SDTIME"
....more proc olap statements
and later the actual data retrieval:
ORACLE_85: Prepared: on connection 1
SELECT "YEAR", "QUARTER", "MONTH", "DAY", "DAY_ID" FROM "OLAPTST1"."SDTIME"
ORACLE_86: Executed: on connection 1
SELECT statement ORACLE_85
Maybe that's what you are seeing?
... View more
