As to; '@{ca6aab9a39bac1758}'; that looks like a presentation variable to me, which would be defined in your BI Dashboard / OBIEE Analysis, it is more usual to use the column references with Writeback though; @{c0} @{c1} etc - see ->…

Yes, but does your weblogic / administrator user have specific rights to that file on the OS? i.e. If you are in Oracle what does ls -f yield on the file?

Have you checked that the Oracle BI user has the necessary rights to your xml file?

See agents -> https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-2479D256-AB7F-4BBE-925C-E71DF1F83D27.htm#BIESG3465

See also; - blob image in bip report

Sorry - I missed the BIP part, have you seen this -> https://blogs.oracle.com/xmlpublisher/inserting-blobs-into-your-report

You might want to give this a look -> Blog : How to Use Blob Datatype Files Within OBIEE 12c

Point taken and totally agree. The difference between following a script and providing zero added value OR actually having insight and being able to field questions and suggest better alternatives.

I may be biased but I used to deliver the training (and update it) when I was working for an Oracle Partner, feedback was generally very good as we were also consultants / implementors / developers / architects (bring your own brush) I got mixed feedback from people who went on the OU course directly from Oracle. And no…

Hi, you might want to have a read of 'kimball data warehouse methodology'. You might also want to get yourself on an advanced rpd modelling training session from a reputable Oracle partner or Oracle University. If you question is answered then could you kindly close this question for the benefit of others. If you are…

Yes, looks good to me! Assuming it reflects your data architecture?!

Hi, for the benefit of other users can you kindly mark Gianni's answer as correct and any others that helped you get there as helpful - this tells others that Gianni is a genius with OBIEE and that if they have a problem like yours which answer worked for you.... I think you get points for doing so too, so everyone is a…

You might want to give this a read; - https://docs.oracle.com/cd/E11882_01/server.112/e10729/ch6unicode.htm#NLSPG006

re: @Gianni Ceresa 's comment "because the model you have isn't really matching the business needs you try to solve" - ideally this means you go back to the ETL and add your additional logic there, then your answer is precanned and fastest. Possible but not as performant would be to put the logic along with key(s) to hook…

Only been following this peripherally, but you might want to have a look into lookup tables with OBIEE - https://gerardnico.com/dat/obiee/obis/logical_sql/lookup_table - if you have a single key, or could concatenate a number of values to a single key and you can construct and populate the lookup table (or view equivalent)…

Looking back at your original diagram; - I would expect provided you have your content level set properly and the right granularity table to table that any analysis with calendar, account (F), payment (F), payment (D) should come out with the right results. If you introduce Account (D) or Client (D) into the previous…

OBIEE is star-schema-centric. If your data sources are not star schemas then typically you are into (at least to some extent) modelling 3NF territory, which is more complex and invariably less performant. If you are modelling 3NF then typically you start by making facts out of the most detailed level of table and joining…

Hi Alex, I could help you more if you could confirm if your model adheres to my 1,2,3 above - but... example of what would work, note showing 3 facts but could as easily be 53. Physical; - Account_F - fields; Calendar_FK, Account_Id, Account_Value Payment_F - fields; Calendar_FK, SomeOtherDimension_FK, Payment_Id,…

Hi, You can only have correct numbers with multi-fact analysis if ALL dimensions that are used in your analysis are; - 1. Connected directly to all facts 2. Not cross connected to other tables 3. Have appropriate content level settings fact to dimension (both sides) with data existing at the level of granularity set (say…

Sorry, think this is a communication issue - I was asking what error message you see when you run the analysis, or does it not error, just not give you the correct / expected number - if the latter how is it incorrect? thanks, Robert.