And you have nothing like row level security on these tables? Does looking at 'complex_view_on_db' give you any clue as to its purpose?

Any logic on the connection pool that could cause this?

Look like using an ETL of somekind to model this into a true dimension table is your only option.

Hi Michal, do you have a condition on the reports to prevent them being sent when no rows returned?

I think you are misunderstanding @Christian Berg 's answer - "Attributes do not belong in the logical facts....." Physically it is okay, and sometimes even more performant, that Facts have attribute fields. But in the business model layer the Fact should have measures, the Dimensions should have attributes. So you model a…

Many thanks for the reply, much appreciated! Robert.

Sorry, I have not implemented the exact filter that you describe, and I suspect that your requirement is specific to your business, so to achieve this you really need someone locally who can write sql in conjunction with a functional HR specialist and yourself to explain your exact requirement. The key question you need…

Hi, to do this you need; - an sql query that would provide the row / rows of data for each user to create the variables to hold this row level initialised data an init block to be defined to populate the data for the session this to be then associated with the users via the mediums of groups set up for the purpose (i.e.…

Hi, thanks for your input, the issue with this proved to be that the solution was only updating dimension tables, and as such we had not added it to a FACT group. When we added it to a fact group then it works, even though in this case the solution is entirely factless. Hope this helps someone else who finds themselves in…

Hi, 1. open the subject area in answers, expand the dimension and fact folders. 2. open the rpd in the Admin tool and expand the dimension and fact folders in the presentation layer. 3. Compare the 2, the fields you cannot see in the subject area are hidden.... Or 1. open the rpd in the Admin tool and expand the dimension…

Hi Jessica, OBIA is designed to be configurable to take data from a variety of prebuilt data sources under the wider Oracle group; Oracle e-Business suite, JD Edwards, Peoplesoft etc; however this flexibility means that your software partner as a sizeable configuration task to configure the solution to consume data from…

Hi, if two reports share the same subject area and the target report is filtered 'IsPrompted' then it should catch the prompt from the source. if the situation is not as straight forward then you may have to find a way to bind the variable(s) (using presentation variables typically) and place an associated filter on your…

Anyone have any insight on this at all please? As it stands I have two options, neither of which I am keen on; - 1. Amend one of the standard scenarios to call the custom scenarios when it finishes - problems; will lose this come the day the client upgrades 2. Create a wholly new load plan and run it independent of the…

Thanks for your input, can I just confirm that I understand you correctly. The answer is to EITHER remove the Authenticated User application role (presumably the other roles do not inherit rights from Authenticated User?!) OR Add additional filters to the AD string Is that what you are saying? Many thanks, will mark as…