Hi, Saved customizations of a users are stored into his own personal folder <CATALOG_ROOT>/users/<username>/_selections , shared customizations are saved next to the object, so if you save a shared customization for a dashboard page you have it in <DASHBOARD_PATH>/_selections . Just keep in mind you are not supposed to…

Hi, The "Freeze column" option is possible only in some columns bases on your layout. How does your dashboard page looks like (how are columns placed in it) ? If you add 2 columns one next to each other you can freeze the one on the left, if you put 2 columns one above the other you can freeze the one on top etc.

Hi, Do you want to call a DB function in an analysis or do you want to do a direct database request? Because it's 2 different things. So if you want to bypass almost all the functionalities of OBIEE and use it like if it was SQL Developer (a free tool) you simply go on "New" > "Analysis" and there you select "Create Direct…

You run it from a Windows or Linux machine (or VM) able to connect to the DB where you want to create the RCU schemas. RCU doesn't require any link with something installed locally on the host running it, it just create things in the DB, so you can run it from where you want as long as you can reach the DB server (so no…

Hi, as your screenshot are missing (smells like a copy/paste of something you posted somewhere ...) how did you created the 2 LDAP? Are they 2 authentication provider? What are the values of the "control flag" you defined for these 2?

How are your network settings? Using DHCP? Having a firewall on it? Is the IP of your test-bi01 host still 172.30.101.16 ? Next time post some extra details like OBIEE version, OS and context (VM, server, your own laptop etc.) ... Ok it's 12c, but if you post it you avoid to be asked for it ...

Before to try to improve something you must identify what you are supposed to improve. "Improve report performance" doesn't actually mean anything in OBIEE as the report performance is a mix of multiple applications talking to each other, so until you don't start by finding out where time is spent there is nothing to…

Right data or data compared to what? The first thing is to find out where the issue is: is your data available in the DB? Does your report connect to right DB? What kind of query does your report generate?

Hi, Why don't you just add column x in Analysis 2 as hidden column? If you have column x in Analysis 1 and few others columns that are shared between Analysis 1 and Analysis 2 (or it would be impossible to sort the way you ask) column x can perfectly exist in Analysis 2 as well... Because there is no way to say "please…

The REPEAT() function? this one will just output the first param as many times as the second one, so how is it supposed to give you end of month for all the months? REPEAT('abc', 4) => 'abcabcabcabc' (so 'abc' 4 times) And CASE WHEN will never generate any rows of data, if there aren't dates somewhere in the dataset it…

Hi, Can't export in Excel ? Because CSV is into the "data" group of export options, and these formats doesn't export the visualization you define in the "Results" tab of your analysis but export the content of your "Criteria" tab. If you add in "Criteria" 5 columns to your analysis but in the "Results" tab you define a…

Hi, In the properties of your table view you have setting for that. Set it to "Column Labels" = OFF.

Hi, what does it means "for all months" for you? Because there is an infinite number of months .... Somewhere you must have dates or months or something and if you use that instead of CURRENT_DATE you will be able to calculate the last day of the references month. Remember OBIEE never generate rows from nothing, so if you…

Did you try searching in the forum? How can i update S_ETL_DAY after 2016 Ian Bristow-Oracle wrote:... there is bug 21835891 - USAGE TRACKING ONLY HAS DATE DATA UNTIL 2016 Regards,Ian Bristow And as @rmoff says your usage tracking perfectly works, it's only your reports not showing data for 2016, but your DB is still…

Hi, As the embedded LDAP is a normal LDAP any python script able to query an LDAP will work. It looks like there are many simple ways to interact with LDAP using python.

Hi, This works (as you saw) but it is not the official way to do it and you saw it by yourself: adding files in the default system path is ignored during an upgrade. That folder can also be deleted during an update or any other similar action. You are not supposed to touch in any way the default folders and their contents.…

2698823 wrote:So can anyone advise how to solve it.. How ? Well ... add a time column or save the time with the date (so date time). Of course you can always take the daily amount and randomly split it around in 3-4 pieces to just generate random values by hour (PS: this is a joke, don't do that !)

WITH tmp AS (select departmentfrom employee_departmentwhere sup_full_id =UPPER('User1'))select department from tmpunionselect department from employee_department where 0 = (select count(*) from tmp) Something like that is supposed to work : if you have rows for 'User1' it returns you a DISTINCT on that list, if nothing…

Hi, You have full access to everything, so yes for 1, 2 and 3. For 4 is a yes as well, but of course the VM is setup to run what it contains, so you will maybe need to add a new disk or things like that and install some other OS packages etc. SampleApp is the only official Oracle OBIEE 12c available VM.

Hi, You have an example to get last year, so to have what you look for you must use TIMESTAMPADD() and DAYOFMONTH() and do some calculation ... The key is to get the first day of the month and then move around from there. With DAYOFMONTH() you can have the number corresponding to the day of month of the date you pass as…