Hi Donald. No worries. It was an interesting learning. Never thought about using Function on WITH clause in BIP. An old workmate once told me while running SQL on different tools. "We have two pieces of software talking with the database. They make not talk the same way all the time" Cheers Fernando.

Hi Donald. The only weird thing I found in the engine log was. [dv id:1293682950]Validation code:DM08_COLUMN_ALIAS_LENGTH[dv id:1293682950]Error Type:WARNING[dv id:1293682950]Description:Selected column length name exceeds the limit of 15. Length of the column name must not be more than 15 chars. Use short alias for column…

I'm in NZ so I change my Timezone to Sydney. The first image is the result I got.

Hi Alberto. This is always tricky to setup. I used this kind of report to check the proper configuration that worked for my users. You my try on your setup. Also check the DM column configuration and play with User Preferences. I think you need to logoff and logon again for each time you change the User Preferences. Hope…

Hi Jonathan. As far as I know that is not possible. https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-AF9605D4-56E5-4EEF-AEC2-559A103091C0.htm#BIPRD2211 Cheers Fernando.

Hi Niketa. Thanks for your reply. Based on your previous comments that the process works fine when you don't zip, I think you have a bug in your hands (unless someone else has another view). It will be good to open a SR for Oracle Support. Cheers Fernando

I'm really sorry Niketa. I asked about the wrong parameter in the bursting definition. I mean to ask PARAMETER5 (Remote File Name) as you are sending the data to FTP right? Cheers Fernando

Hi Niketa. On your bursting query. How is PARAMETER2 (File Name) defined? Cheers Fernando

Hi Jonathan. Any chances to ask for that permission (enable EVALUATE)? Here another example with Regular Expression. https://gerardnico.com/dat/obiee/obis/regexp_evaluate Or another way would be to sort this in the database (or in the repository) creating a new attribute there.Not sure if possible as I don't know how are…

Hi Jonathan. Try Evaluate. Something like this but you will need to work out how to build it to fit your purpose. EVALUATE('REGEXP_REPLACE(%1,''^[A-Z]+'',''*'')' as char ,<you Dimension Level here>) Gerardnico still useful on this case as you are on 11g. https://gerardnico.com/dat/obiee/obis/logical_sql/evaluate Regards.…

Hi Osama. Check the following link for Non-Standard SQL Data Sets. Creating Non-Standard SQL Data Sets Cheers Fernando

Hi Lisa. As far as I know that is not possible. You may do usage tracking. Oracle Support Document 1532638.1 (What steps need to be performed to implement Usage Tracking of report and analyses execution for OTBI/OBIA and BI Publisher) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1532638.1…

Hi Josh. Check Nathan reply below. Cheers Fernando

Hi Joshua. I think you need to use Localization to achieve that. Check this Localizing OBIEE https://docs.oracle.com/middleware/1221/biee/BIESG/deploylocal.htm#BIESG1824 Supporting Multilingual Data https://docs.oracle.com/middleware/1221/biee/BIESG/deploylocal.htm#BIESG1757 Fernando 

Hi Jonathan. Sorry. I posted a comment (and deleted) as I got into a confusion with Item Number Not sure if that is possible. What is the business case for this? Just trying to understand better. Cheers Fernando.

Hi Silvia. In addition to Gabriel's post. It all depends on the WHERE clause you have in the report data model. If explicitly gets only the records from the previous day it will not get users registered on Tuesday (if that is the filter being used in the data model). Cheers Fernando

Hi Donald. Forgot about some options in the Data Model. The following works. Type of SQL: Non-Standard SQL. I used this code in my Data Model just to test. WITH FUNCTION GetValue1 (p_value VARCHAR2) Return VARCHAR2 IS CURSOR c1 IS SELECT 'aa' aa FROM dual WHERE p_value = 'ABC'; cc VARCHAR2(100); BEGIN FOR x IN c1 LOOP cc…

Hi Donald. I would transfer the function to the database instead of being part of the WITH block. Especially if you plan to reuse it. I like the challenge so I will do some tests too. So far I don't know an answer for the workaround in the Data Model. Hope someone else has the same issue and come with some ideas. Cheers…

Hi Donald I think the first error was because of the following part in your original code. FOR x IN c1 LOOP cc := x.aa; END LOOP; RETURN cc; [2019-11-18T07:54:45.258+00:00][dp id:463169166][sch info:]Bind Variables ... [2019-11-18T07:54:45.258+00:00][dp id:463169166][sch info:] 1: :null [2019-11-18T07:54:45.259+00:00][dp…

Hi Donald. This is just me and my standards, so ignore this first lines if you want. There is one thing that always bugs me when I see some Data Models. It is the "SELECT * FROM table". It may not be the your case but, if something change in the table structure your Data Model will be affected and you are selecting more…