What I am suggesting is as per; - TW OBIEE: Using a FILTER Function Instead of CASE Statements So instead of applying your filter (as in where condition) in the normal way you use it in the USING .... clause, with your Denominator is either just the base measure or a static filter, depending on the complexity of whatever…

Could you use nested Filter - the Filter created via formulas with the dyntax accesed from the function syntax palette to make one part static, the other half dynamically filtered?

Yes. Your keys tell OBIEE the granularity of all attributes in a dimensìon hierarchy level. The content levels tell OBIEE the granularity of how fact joins to dimensions, as controlled by the content levels set on both sides logical table sources. The current selection of keys and setting of content levels is of critical…

Yes, exactly that.

Okay, assuming the aggregation on flag is 'count distinct' (tell me if not) then your only other problem could the keys / dimension hierarchies on your dimensions, logical table source content levels from the keys, and the underlying physical table structure. Can you show screenshots of these elements and I can assist…

Which of; - flag job job_group Come from a fact table, which from a dimension?

It should happen automatically just by pulling the measure / dimension attributes into the analysis - IF you have the attributes in dimensions AND the measures in the FACT folder - if not then there is something badly wrong with your subject area and you really need to redevelop it, it is just plain wrong. Not sure how…

re: grouping If your attributes are on dimensions then they ALWAYS group - unless you are using a non-aggregating measure!! So if your measure is count distinct 1, and you pull in Job and Job Group and you filter on the job then you get the equivalent of; - select count distinct flag, job, job_group from whatever where job…

Can you tell me where the 3 elements site i.e. Flag (1 / 0) = fact Employee = dimension Job = dimension Correct me if I am incorrect please as to the source of the three?

Sincere thanks for providing company / moral support on this one...

re: for example see -> https://www.oracle.com/technetwork/middleware/bi-enterprise-edition/tutorials/obiee-obe-167892.html

OBIEE is not query-centric, it is data-centric. You need to build your repository correctly to support this. Your fact should have all of the measures, and keys to Job Group Dimension, Job Dimension (with your job number in?) etc Your flag will be in one of the dimension tables You then create an analysis pulling the…

Do you mean your flag is 0 or -1 for true or false? - as often seen in MSSqlserver? If so, this does not make it a measure, it is still an attribute, a measure is something you can meaningfully aggregate, you cannot meaningfully aggregate the equivalent of true,false,true,true?!

Not sure if you are talking to yourself or me now, but here goes.... Provided you have the rights there is a feature called 'Direct Database Request' - this is a TESTING feature which is often misused to create emergency pieces of sql - my advice - don't go there - that is not the point of BI. When you run direct database…

You can do count (or sum) by X in a formula in OBIEE to achieve the same result; - count(distinct a_flag by number) But, and I hesitate to ask as it just looks so wrong, what is number in B_FACT, is this a foreign key?? And why, is a_flag in your fact table - it should just be measures and keys? In short, what is this BI…

Quote - "If you downloaded an existing template and want to upload the modifications to the template, then select Upload Template from the Oracle BI Publisher menu. If this is a new template for the report definition, then use the Upload Template As option to upload the layout to the report definition on the server. Also…

Actually no, I would expect a link to drill out to the system holding the image. I number of years ago I implemented an archiving solution. In a number of instances it was useful end user information for them to be able to access images; - invoice scans, notes, sales bumf, P60s etc. In no instance did I make the BI…

Yes - so you need to check the rights on the new server, this is not like just moving catalogue / rpd.

Seriously - I saw your hospital is oncology, if this were me I would not want to display images via your BI solution, I would want to ensure that only specialist medical imaging technology was used with highest resolution and zoom in facilities - this is a matter of life and death - and for my sins I too worked in health…

Hi, I am a big believer in the right tool for the right job, and whilst BIP does claim to be pixel perfect etc I am fairly sure Oracle did not envision or design it such that it would be fit for purpose to be used for an image archive accessing solution, and particularly as you are talking medical images I would be very…