Hi @Raa.BI , you can create a simple report using REGION , TİME and UNITS colums (I assume that UNITS column is a measure that have SUM aggregation on rpd level). Then use the formula like this for UNITS column CASE WHEN ("TIME")=8 THEN SUM(FILTER("Units" USING ("TIME")>=8) BY "REGION") WHEN ("TIME")=9 THEN…

Hi @Khalid Ibrahim What is your OS ? If linux , there is a document related to how to make faster services scripts in Linux OS. Maybe it helps you OBIEE 12c FAQ: Why Does The start.sh | stop.sh | status.sh Script Run Slow? (Doc ID 2069626.1

No , we are using SQL Server driver. ODBC to repository schemas like below.

In rpd ,QUERY_BLOB column type is LONGVARCHAR(32768)

Yes , i checked obis1-diagnostic.log and there is no error about S_NQ_DB_ACCT table. However , I tried to create direct sql report using S_NQ_DB_ACCT. If i don't use S_NQ_DB_ACCT.QUERY_BLOB column in query , there is no problem , query is executed without error. If i use S_NQ_DB_ACCT.QUERY_BLOB column in query , query…

Sorry Christian , I've just created my own thread which is "OBIEE 12c Usage tracking problem" . If you have any idea , can you share ? Regards

Hi Gianni and Christian , i've similar problem. After configuring UT ,session logs have been inserting S_NQ_ACCT table but have not been inserting S_NQ_DB_ACCT table. Not only graph reports , I can't see any data in S_NQ_DB_ACCT. Did you know anything about this issue ? NOTE : Repository schemas created in Microsoft SQL…

Hi Arünas , If you have OBIEE 11g environment , could you please try after copying "fonts" folder from 11g environment (<Oracle_Home>/Oracle_BI1/common) to 12c environment (<Oracle_Home>/bi/common) ? Also related documentation is OBIEE 12c - Turkish (Non English) Character Is Missing On Pdf Export (Doc ID 2097276.1) Regards

Hi Charles , first of all thanks for reply. I solved the issue. First , I added <DefaultRowsDisplayedInDownloadCSV>100000</DefaultRowsDisplayedInDownloadCSV> parameter under both <Table> and <Pivot> tags. After this configuration , obips1 cannot start. Because <DefaultRowsDisplayedInDownloadCSV> parameter is not supported…

Hi , We are on 12.2.1.2 but still not able to export csv more than 65001 rows. Parameters that instanceconfig.xml have ; <ODBC> <ResultRowLimit>999999</ResultRowLimit> </ODBC> <DefaultRowsInDownload>999999</DefaultRowsInDownload>

Hi , Windows 2008R2 is not supported for OBIEE12C. By the way , don't forget set "BI_PRODUCT_HOME=.../..../..../Oracle_Home" environment variable.

Hi , you're right there is no "Pwd is wrong" text in bi-lcm-rest.log now. But before when i tried to upload same rpd with same password, i am sure i received "Pwd is wrong" error message. I did not change anyting while uploading but now error message different. Anyway , i tried 5 minutes before and bi-lcm-rest.log file…

Hi, version is 12.2.1.0.0. bi-lcm-rest.log is here xtermxtermxtermxtermxtermxtermxtermxtermxtermDec 14,2016 09:43:11 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - upload Rpd called for: ssi Dec 14,2016 09:43:12 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - Deploying RPD file: /home/Oracle/Oracle/Middleware/…

Hi , first configure OBIEE using "Clean State" option. Then try to import test_export.jar file

Hi , Windows 7 isn't supported version. Supported versions in windows are "Microsoft Windows x64 (64-bit) 2012" or "Microsoft Windows x64 (64-bit) 2012R2".

Hi , i have test BI system on windows and have production BI system which installed on Linux. I downloaded rpd from test system(windows). For example : rpd password that is downloaded from windows system "test123". I am able to open rpd using password "test123". When i try to upload rpd to production system(linux) using…