Dimitris Karydis wrote:(I suppose I had to use the quotes to make it a string??). To make it a string in the physical query. The value of a formula is sent as such to the DB, which allows you to query dynamic columns by storing their names in variables etc. So to not make your physical query invalid you need the quotes…

As Robert said, I guess the 2 values are just separated by a comma ',' when looking at the variable from a "text" point of view. Display the variable to validate the separator and then substring based on the position of the separator (or also the X characters from the right of the variable if your weeks IDs are always 7…

Just 2 details: You may want to consider updating your OBIEE to a supported version as supported for 12.2.1.0.0 ended a while ago (and it's also a first release, so with all the issues going with it). If you want to change a file in a style do not edit files like you did but create your own custom style (even just a 1-to-1…

3357027 wrote:Hi all thanks for your response and clarification,but I just wanted to know , can the text file be directly used to create the report and can it be refreshed ?where the file will be stored, can't we just replace the file in the filepath, and will it get refreshed.? You just had to read above, answers were…

So ... for 1) JS can do it, sure. But I join Christian in saying it's a bad idea. So it's easier to say "not possible" as it avoid people to destroy their instance. JS can do all you want with the OBIEE UI as it's a webpage. The issue is that it's not a simple nice static webpage, most of it is loaded asynchronously, with…

Do you really need to grant these things? OAC01_BIPLATFORM is the owner of the S_NQ_DB_ACCT table, so by default I would imagine it already has all the permissions on it... You need that grant if you use a different user.

The file being big (GBs) is an additional reason to load it into a database. OBIEE is not a database server, its performance when accessing data is definitely not as good as a database, which is developed for that reason while OBIEE has many other targets and accessing data files directly is just an extra feature they…

If you load the data in such a way you can't replace the file, if you need to use a new version of the file you need to upload it again (it will replace the existing one). Everything can be automated in a way or another, the question is more to know if you aren't looking at the wrong solution for your need ... Files based…

How is that different than ? It's against the rules of the forum to double post, and if it's urgent hire a consultant to do the job. You are paid by your client for that job, we aren't paid to post on the forum, we all do it in our free time instead of doing other things ... PS: you still didn't manage to spend 30 seconds…

As linked above the scheduler uses 4 tables where it stores things. Each job execution is logged there with a status. If you look at the table you easily figure out the columns and their meaning, or also search here around as some days ago somebody was asking about a monitoring dashboard for agents and he got a reply with…

So you have an analysis which you send to a user using an agent. And now you want to send an email to another user if the first agent didn't work fine? You have the logs tables of agents (https://docs.oracle.com/cd/E17904_01/bi.1111/e10541/schedconcepts.htm#BIESG1430) which allows you to know the status of the agent…

Hi, did you check the official doc (https://docs.oracle.com/middleware/1221/biee/BIESG/cluster.htm#BIESG9281 ) ? They cover all the steps required on both servers. As alternative just searching in Google get you https://www.peakindicators.com/blog/installing-an-oracle-bi-12c-cluster and OBIEE 12c - Horizontal Scaling - Red…

3514884 wrote:I have been searching for any sample step by step kind of info for a sample report for hands on. In case if anyone has please revert here. Simpler than copy/paste from the working real examples in OBIEE? Do you actually know and JET by itself and can use it easily? Because if you don't know JET the thing to…

Possible it's possible. Keep them totally separate, they don't have to share anything: separate on file system, separate on ports range used.

https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2147135_1.html Most of these topics are covered by MOS documents.

No, because when you are in the views it's too late. Inline prompts will filter the query like dashboard prompts, so when you have your table, pivot, chart the dataset is already filtered by the values selected. Give a try to master-detail, it's the only one which could still give you a similar filing as prompts in the…

Hi, Prompts exists only at 2 levels: dashboard prompt or analysis prompts. You exclude the dashboard prompt as you want to stay inside the the analysis, so you can use the inline prompts. When you open the analysis you will see the prompts, you select your values and then the analysis shows you the result. They work in the…

What's your target? What is defining the size of the iframe? PageContentOuterDiv - 50px seems to be a bit of a random approach where you fixed 50 as enough to show other things taking some space on the screen.

Explain what you in details, what step gave you that, what document you were following. Because otherwise can't do lot more than point you to the official doc ...

Dennis Hancy wrote:...But it looks like it's only printing the filters on the analysis... You print an analysis and the filter view show you all the filters applied to that analysis. As you said: the prompts are on the page, not in the analysis, so you can't expect that printing the analysis will give you the prompts, for…