This discussion is archived
0 Replies Latest reply: Jan 9, 2013 7:31 AM by KurtGeens RSS

Mix fysical column sources with logical formulas

KurtGeens Newbie
Currently Being Moderated
To enhance performance on a report containing time series (year ago) values, we want to create an aggregate for the fact table that is used in the report. This aggregate will be added as source to the logical fact table in the OBI Administration Tool (of OBIEE 10g). Currently this table contains a logical column DENETBG_YAGO which has as formula "AGO(DENETBG, year, 1)". The aggregate however contains a column 'DENETBG_Y1' which already contains the DENETBG value for 1 year before. Is it possible, and if so how, to add this column as source to the DENETBG_AGO logical column? I can't figure out how to mix the logical AGO-function and the fysical column in one logical column.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points