Good time! In your case, tnsnames.ora should be located here: C:\obiee_12c_admin\network\Admin\tnsnames.ora

Hi 3310714, Yes, cnahges will saved in repository. Another developer should open RPD-file you have already changed - then he will see roles, that you added. If another developer will upload the repository without your changes, then your added roles will be lost

Good time, 3310714 You can add application roles in offline-mode by hand: OBIEE 12c: application roles not visible in Identity Manager

So, that is bug. Ok. Yes, i will make SR Sherry George, Ebin Cherian - thank you

> Just a thought, the AGO function uses the date hierarchy in its inputs, does the user in question have rights to those, or is your date hierarchy not exposed in the presentation layer? Hierarchy was maked in PRD. And was moved to presentation level (defauls permissions) User see it > And, is the AGO created in the rpd or…

Hi Christian No: Read for Authenticated User And Default for other roles This is true for all columns and folders in subject area

Hi 1. Correct path to XML-templates .../bi/bidata/service_instances/ssi/metadata/content/msgdb 2. Your XML-template, that was made here - will active in the english-interface .../bi/bidata/service_instances/ssi/metadata/content/msgdb/l_en/customMessages/<YOUR_XML_TEMPLATE> If you enter to analytics using english-interface,…

Hi! 2) Yes, it's possible Properties of Presentation table -> tab "Child Presentation Tables": Here you can set subfolders for main folders Finally view in presentation services:

Hi 3310714, you not alone with this problem As write Mark T. almost a year ago: Starting with OBIEE 11.1.1.9, Oracle made a design decision to remove the single-click synchronization of roles between Fusion Middleware and the OBIEE Repository. This design decision requires us to manually create roles in the Admin Tool that…

Hi Mr Sausages > You can probably try changing <ConnectionPoolSize> to 10 or Maximum Connections in Connection Pool to 20. I checked many-many different cases - set different values to "Maximum connections" (in repository) and to "msmdpump.ini"-file. And this case too - i experimented with different values of…

Hi Mr Sausages No. I have a long correspondence with the oracle support about this theme. But we have not found any positive result Support-master advised me to change the setting UserPopulationQueryTimeoutSecs from file /.../ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS/instanceconfig.xml in tag…

Gianni Ceresa написал(а):1+CHAR_LENGTH('10,12,14,16') - CHAR_LENGTH(REPLACE('10,12,14,16', ',', '')) In this case, the solution is suitable for me. Thanks, Gianni Ceresa Christian Berg, thanks too

Hi Check the permissions in the connection pool

Hi In connection pool (in physical level in repository) - user, that you use for connection with DB, can write/delete data from the your table? - also check the permissions in the connection pool And add <WebConfig> <ServerInstance> <LightWriteback>true</LightWriteback> </ServerInstance><WebConfig> to file…

You have table "Calendar", good. But the field CALENDAR_DAY_of_the_week filled not as you need Now you need to fill in the fields of the table so that 26.06.2016 was the first day of week, 02.07.2016 was the seventh day of week (most likely need to use a new column) This query is dinamical: SELECT DATEFROM CALENDARWHERE…

It was sql-query for OBI. If you want make dynamic variable, you need use classic sql: ALTER SESSION SET NLS_TERRITORY = AMERICA;SELECT TRUNC(SYSDATE) - TO_NUMBER(TO_CHAR(SYSDATE,'D')) , TRUNC(SYSDATE) - TO_NUMBER(TO_CHAR(SYSDATE,'D')) + 7FROM DUAL; This 'D'-element returns the number of the day of the week (1-7). The day…

Hi! SELECT TIMESTAMPADD( SQL_TSI_DAY , 1 , TIMESTAMPADD(SQL_TSI_DAY , DAYOFWEEK(CURRENT_DATE) * -1 , CURRENT_DATE ) ) , TIMESTAMPADD( SQL_TSI_DAY , 7 , TIMESTAMPADD(SQL_TSI_DAY , DAYOFWEEK(CURRENT_DATE) * -1 , CURRENT_DATE ) )FROM [YOUR_SUBJECT_AREA]

Hi 'SYSDATE ' is not current date. It's text You need used special repository variable, or system function "Current_Date" CASE WHEN "Planner WorkBench"."DW_SUPPLY_DEMAND"."PROJ_OUT_DATE" <= Current_Date THEN "Planner WorkBench"."DW_SUPPLY_DEMAND"."QUANTITY" ELSE 0END

2016-06-14T09:34:17.000+02:00] [OBIPS] [ERROR:31] [] [saw.writeback.execute] [ecid: 920fd1ffeb301c62:6f5da33b:151414550f8:-8000-0000000000b11045,0:1] [tid: 974960384] Could not find privilege: [[ Check permissions In repository 1.1 in connection pool (for test - give permission to read/write to "Authenticated User") 1.2 in…

Try replace string <WebMessageTable embed='true' lang="en" system="WriteBack" table="Messages"> to <WebMessageTable lang="en-us" system="WriteBack" table="Messages">