Hi
I've build a report in OBIEE 11G where i'm presenting some columns from W_GL_OTHER_F.One of the columns is journal source.
If journal source is 'AR' or 'AP' , I need to present the last user who updated the transaction.
The data can be found in the columns W_AR_XACT_F.CHANGED_BY_WID and W_AP_XACT_F.CHANGED_BY_WID accordingly.
All the three tables that i marked above (W_GL_OTHER_F,W_AR_XACT_F,W_AP_XACT_F) are joined to the table W_GL_LINKAGE_INFORMATION_G.
So I created a join between W_GL_LINKAGE_INFORMATION_G and W_USER_D in order to bring the "LOGIN" field from W_USER_D.
But after i did this step and tried to bring this field (LOGIN field which is called: X_LAST_CHANGED_BY_AP) to my table in OBIEE, i got the following error message:
[nQSError: 43119] Query Failed: [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Ledger Detail,,,,,,,,,,,,,,,,,,,,,Fiscal Period,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - GL Journal Details.Journal Header, Dim - GL Journal Details.Accounting Document Source, Dim - GL Journal Details.X_CREATED_BY, Dim - GL Journal Details.Creation Date, Dim - GL Journal Details.X_DESCRIPTION, Dim - GL Journal Details.X_DOC_SEQUENCE_VALUE, Dim - GL Journal Details.X_POSTED_BY, Dim - GL Journal Details.X_LAST_CHANGED_BY_AP],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,]. (HY000)
Can someone please advise what should i do in order to create the join connections correctly?
Thanks
Yaron