Do you actually have a date dimension not linked to "procedure date" and "report date"? If you don't and with just access to the front-end you can't do much: OBIEE will never generate rows which don't exist in the result of the query, the query is driven by the model (to which you don't have access as you said). That's why…

Steelbird wrote:In Data base I can execute this select TRUNC((SYSDATE) + 14/24) from dual; but How can we implement this in obiee ("Time"."Date" + 14/24) ? In every place where you can enter formulas you generally have a helper with the list of available functions and there is a group of them called "Calendar/Date", have a…

At some point even the business is "smart" enough to understand you can't change the product and expect the exact same behaviour, or .... why did you even change and gave up on BO? As said, you are cheating with the tool, so play the game of how the tool is developed! Agents are meant for users, this means users is a way…

Every OS, Windows and Linux included, have ways to recursively search for a file based on name in a given path. Sounds like a legit way to find files ... Or the doc also has references to all the paths (and in google you can find it as the first link for a search result).

4117887 wrote:...or with out OBIEE... For this one, pick whatever other tool on the market doing the kind of analysis you look for and deal with it. As said agents are targeted on users, therefore that's how you could cheat. Link the various locations to different users and change your analysis to be reactive to the user…

Let's take a step back: what is the original requirement? And not what you imagine it is (like the GOURL thing ). If need to embed some OBIEE content into something else there are the webservices, ADF has other ways to do it as well. Authentication would need to be done by some kind of SSO if needed, or if you use…

Agents are meant to target users: the content is generated and sent to users, not wrote on disk. This means that either you have as many agents as you have values in your prompt and you set each and every single one to a different value, or that you have different users which by their setup have different content in that…

2668432 wrote:RPD was not touched at all during the prod freeze and not opened in online mode too. 6. How do you know nobody/nothing touched the RPD on your PROD environment?

There are lot of possible options. First thing is to make sure OBIEE is the issue, maybe OBIEE does everything fine and it's your mail server messing with it. Also important to find out if recipients are correctly retrieved, if they are defined list of users, email addresses or dynamic lists generated on the fly. Check the…

ee2fe9d2-6b10-41af-bc5e-bb8ee754cd61 wrote:This makes me think that there might be a limit on number of objects that a folder can contain. Not really, but the catalog page in the UI has limits in the number of objects it can retrieve. These limits exists and are actually set at 300. The Presentation service config file has…

Is your 12c install on https://reporting... or do you have a proxy in front to give you access to it via HTTPS + domain name and terminating SSL at the proxy level and send requests back to HTTP + weird/not-nice servername ?

Before to turn off the lightweight SSO, are you that's what you need? Because your GOURL passing credentials will work, but you will maybe break something else people use for real. Before to turn if off, make sure you understand what does the lightweight SSO and that you can confirm nobody needs it. There are many ways to…

TONIOTONIO wrote:Thx Gianni, please can you delete IP address? Again, there is no reason for keeping this information "secret" as it's a private IP address, it isn't routable. https://en.wikipedia.org/wiki/Private_network Any router will drop any attempt to connect to that IP as it's for internal use only. There are…

And what (exact) version is your OBIEE? What security did you setup? SSO? PS: your link still had the original IP inside, 10.xx.xx.150 apparently. You can post that kind of link in full text as it's a private IP address and it only works locally inside the network of your employer. Nobody from outside can even try to…

You mean to have the numbers also on the 2 stacked bars on the right? Because there is a kind of check to see if there is enough space before to display the number, and in those 2 there isn't enough space to display the 2 percentages without being overlapping and weird.

Jonathan Chan gmg wrote:Do you know how to setup the analysis so it shows the most recent value for both "Costed Onhand Amount" and "Costed Onhand Quantity" attributes? I can't, because of what I said earlier: OBIEE is empty when installed. I can start a new OBIEE right now and I will not find a single thing of what you…

Hi, You probably need to ask in a different forum. OBIEE comes with no content, no model, no analysis, no dashboard: just empty. As you are asking a content related question, you either have to ask in the forum of the product you are using (the one which gave you the content in OBIEE) or you will have to explain your whole…

You export it and send it to the other users as DVA file and they will be able to import it and have their own. That's what you have now.

Hi, OBIEE send to an email address. As long as your list has an email address and the mail server knows how to deal with it, that it is a list, and that it has to send the same message to many more people member of the list, all good. It isn't an OBIEE question, it's just your list which must have an email address, that's…

Christian Berg wrote:...the user has to be a "user" in the technical sense. I.e. a valid security principal of type "user". True, forgot to mention that, also because licensing apply: you want to produce OBIEE content by user? That user must have a license as you are using the tool...