See => https://stackoverflow.com/questions/4832056/java-jdbc-how-to-connect-to-oracle-using-service-name-instead-of-sid

To add to Joel's reply, the best way I find when you want something that is not out of the box is to use the nearest equivalent and then change the drop box to custom - the custom will then be populated with a starter for ten that you can subtly edit to get what you want, without starting from nothing...

Sure, BUT, remember the having 1 clause for a dynamically determined period, this is not down to measure levels - though I get where you are coming from, but I am equally certain it would not work this time.... So; - Of this population of 1 in Time from X to Y, how many? NOT - pinned to a day / month / year,…

So if you can redefine the requirement to a finite set of fixed measures then it is achievable. Or you can construct it in an analysis it is achievable. The only other way I can think you could do this is by refreshing a table content at the back end database when they invoke the report - which seems excessive to say the…

That is why I commented - 'it would have to be for a consistent timeframe' - i.e. you can only do this for a day / week / month as a pre-computed measure because of your 'having' clause and the fact that you want the sum of 1. I had a similar requirement once with share of market / share of measure for a dynamic population…

So it goes... I said to Dude! on the ideas forum that sometimes the awarding of points is capricious and random @Dude! this is the kind of thing I had in mind...

Hi, No, I was seeking to refine 'our' thinking into discrete 'packages', partly to ascertain that I had understood your requirement coŕectly, partly to break it down into discrete elements. I can envisage a number of ways this is achievable in an analysis, using one analysis as the filter for another immediately comes to…

Is your requirement in plain english; - By platform, give me the count of (distinct) customers where the customer only has 1 count (not sure what we are counting!) for that platform within a dynamically specified *at run time* time frame? So if you pull; Platform, Customer Id, Count Put a filter on count for =1 (add the…

Sorry, now you have lost me, can you put it as a simple formula please?

What I am saying to you is the way to get your answer is to chop it down into smaller things that you can achieve. i.e. Can you count distinct employee id, by platform etc - yes etc You can calculate ALL of the elements, you just need to then put together all of the simple / physical measures into a new logical measure -…

+2 to Christian. Note generally if you cannot do it with one measure you may be able to do it with multiple measures and you can; - 1. Create logical measures (measures based on measures) 2. Not expose all measures to end users So usually you can do it in the business model layer, without resorting to SQL...

No offence meant or taken, let he that is without typo cast the first scone (sic)

Rovert? Or is it Rover T - my new rap name to rival Snoop Dog?! And yes, I did not lay out the fundamentals...

If it is a timed report you could use a BI Agent to send it to them. But to have direct interaction with the report but not the underlying subject area, no, unless the user has no report writing capabilities - and if they do then you could always implement an alternative no report writer user for them. If it is a matter of…

Amen - stick it in a database, then mass user account maintenance, auditing, addition, deletion becomes so much easier!

On ... various cost centres - I take it these are the same across, so you would expect it to group into a single row? I fear the learned @Thomas Dodds is correct on your business model, but one to try is open the analytics, go to the query tab and delete all columns which are not present in the analysis, if they are used…

How is LY being calculated, is this using AGO functionality? Also, when you say you have tried pivot, do you mean you have tried presenting the data in a pivot table but you get the same result? Finally, are there any additional columns in the data not show in the table above?

I mean you should not create permanent solutions using DDR, they bypass all of the advantages of using OBIEE, if you just want DDR as a solution then you may as well go back to discoverer custom folders... (were it supported)

Btw - others might disagree - but for me direct database request is not a permanent solution, but a temporary tool useful for DBA or developers to get a quick answer. I would model your ddr's into opaque views at the very minimum.

You are telling me that in my 800 users scenario with the users all using one license Oracle would have had an issue with that? That is funny - I did a road show for Oracle demonstrating that very functionality, they even filmed it...