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…

Hi, TIMESTAMPADD(SQL_TSI_YEAR, -1, CURRENT_DATE)

Hi, as OBIEE is a web app just fix it by a CSS style: text-transform: uppercase;

Hi, why to not manage it in the query populating the variable? If there is no value then you return all the values?

Hi, your problem is almost impossible to solve in a user friendly way .... You said you have 10 indicators (10 different prompts fields) and for each one you want to chose AND / OR. But ... What about ( and ) ? indicator1 AND ( indicator2 OR indicator3 ) is different than ( indicator 1 AND indicator2 ) OR indicator3 Make…

Just a detail .... <MONTH COL> isn't the month column in your subject area ! The second parameter of the AGO function is the level name of the time dimension you want to you for your AGO (by changing this value you have day ago, month ago, year ago etc.)

Hi, What have you tried exactly? Did you analyse the reason of the NULL values? If you just make a simple analysis by filtering on a single month can you manage to get a measure and the same using the AGO function? Is is this one return NULL? What does your formula looks like? What does the physical query looks like? If…

Hi, So you want to move all the values of the "Rows" area of the pivot to the right of the pivot itself? (it's not just about text being written right-left, right?) If you want to do that you will not find an easy solution, it would require HTML reworking on the pivot, moving the <td> tags around (from the beginning to the…

Hi, Current_month you have it by the filter on the month column (based on the prompt where you select the month). Add a new column where you use the AGO function on your measure to get the previous month figures. Add a 3rd column where you calculate the variance by using the previous 2 columns. For the AGO function to work…