BI Factfield (from UDDFK) on Dimensional Filter when Creating a Cube Explorer with Three Different Facts
(Doc ID 880694.1)
Last updated on JULY 17, 2019
Applies to:Oracle Utilities Business Intelligence - Version 220.127.116.11.0 to DNU2.2.1
Information in this document applies to any platform.
For a cube explorer with three different facts: SA accumulation, Financial Transaction and Case Fact
(CF_SA, CF_FT and CF_CASE respectively), having "SA dimension" as dimensional filter for all of them, joins to SA fact and FT fact to SA dimension are already defined in OU BI, and for joining CASE fact to SA dimension, one of the foreign keys (UDDFK) on case fact, which will be populated with the SA key, is used.
When trying to save the CUBE explorer with the above configuration, the process does not complete successfully. Instead an error is encountered, as no link between dimensional filter and CASE Fact can be found.
For addressing the missing link issue the 'factfield' in dimensional filter can be used mentioning the join to CASE fact. (ex. tf=CD_SA.UDFx_CD factfield=CF_CASE.UDDFKx_KEY)
Dimensional Filter 1 CD_SA.UDFx_CD factfield=CF_CASE.UDDFKx_KEY
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Questions and Answers|
|Is the described solution correct, considering the fact that there are other fact tables as well in the zone in different measure apart from the one to which the join is mentioned?|