Oracle BI Metadata repository – IV. Tvorba vlastních ukazatelů

Oracle BI Metadata repository – V. Nastavení hierarchií pro dimenze, tvorba level-based a poměrových ukazatelů

Oracle BI Metadata repository – VI. Nastavení časové dimenze a tvorba ukazatelů pro časové porovnávání

Dva způsoby jak definovat vlastní výpočty (ukazatele) v Business modelu

Grand Totals with Calculated Columns - řešení špatných výsledků při použití filtrů.


OBI EE, Time Dimensions and Time-Series Calculations
From comments: Patricia Keane: Hi, can anyone help with ideas on how to set up a YTD or MTD for previous year or month to the current date. With relation to the example in this article for month ago sales if we ran this e.g. on 21st Jan 2000- can we set up another field that would show month ago Dec 1999 till the same date i.e. 21st Dec 1999 ?
Wildmight:Patricia, I’ve solved this problem. I’m not sure why my previous post isn’t shown, but here’s how I did it - it’s a combination of AGO and TODATE.
You create a value - let’s say Sales MTD by just how Mark showed us - TODATE (Sales , month - dimension)…then you create a logical column with the following formula AGO (Sales MTD, Month Dim, 12)
that should give you a MTD measure you’re looking for.

Ragged Hierarchies

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License