Welcome to the Oracle Analytics Community

Products Banner

Syedsalmancs110 ✭✭✭✭✭

Comments

  • I can confirm to you that the approach you are referring to was working in earlier releases. This is not a supported method anymore in the latest releases of BIP as it was considered a security risk. The better option is to create a web page or java program to utilize Oracle BI Publisher Web Services. In this approach…
  • I am not sure but could you confirm whether you have access to your OTBIE environment I mean access to server? because as far as I know its on Oracle Managed Cloud with Oracle having server access and customer/client/user having only UI(analytics/biacm/odi studio/console) access. If you have access to your server then you…
  • Sorry my bad you did mention it in your post Could you confirm what product have you installed,is it Oracl BI Publisher Trial Version? Or go through below link and let us know what product you have installed. http://www.oracle.com/technetwork/middleware/bi-publisher/downloads/index.html
  • You have Installed BI Publisher(BIP) which comes along with Oracle BI Enterprise Edition(OBIEE) Did you install only BI Publisher(BIP) or (BIP + OBIEE)? You can verify the same by checking if you are able to access to below links as per your environment. http://<machinename>:<port>/analytics…
  • In that case you need to apply ONLY Patch 26330183 Oracle BI Publisher 11.1.1.9.170718 from BI Bundle Patch 26092391 and non other Patches Bundle Patch is required, you can find the same information in document (Doc ID 1276869.1) mentioned before. Refer to section "1. Latest Oracle BI Publisher Enterprise 11g Update Patch"…
  • You could find the document for same in Knowledge Management, here is the document Overview of Available Update Patches for Oracle BI Publisher Enterprise 11g (Doc ID 1276869.1)
  • are you talking about OBIEE 12.2.1.2.0 here? If yes then are you sure you have installed and configured OBIEE 12.2.1.2.0? Please note OBIEE Client Tools are used for different purpose like BI Administration Tool for creating RPD(Repository Design) which is used as data model in OBIEE, Catalog Manager is used for managing…
  • Do you already have Time Dimension created in some other datasource? where are you tying to add time dimension and from where? Because its obvious you won't have same in non-modelled data source. But if you have Time Dimension present in some other datasource then you can join your Google Analytics data source data with…
  • Hi Venkata, If suggested steps helped you achieve your requirement then request you to close this thread as currently it is unanswered. If above steps didn't help then please post back the steps you followed to resolve the issue and then close the thread!!:) Thanks
  • Hello There, Please check OBIEE 12.2.1.2.0 Certification matrix, you can check for your self Windows 7 is not a supported OS for any version of OBIEE 12c installation and configuration. >> Go to following link Oracle Fusion Middleware Supported System Configurations >> Check for OBIEE 12.2.1.2.0 certification matrix with…
  • Could you please post the OS details on which you are trying to install Oracle Business Intelligence 12c (12.2.1.2.0), is it windows 7,8,10(assuming from your post as you have said my system and directory structure displayed in configuration screen), if yes then please be informed it is not supported/certified OS for OBIEE…
  • Hello Venkata, 1) >> Right click on the column with decimal values--> In the list of options select "Properties..." >> Go to tab "#"(Value) --> change "Decimal" parameter value to "none" 2) >> To calculate Date in YYYY-MM-DD format using date column you can make use of "Add Calculation" at the bottom of the Project >> You…
  • Hello Zhuo Meng, Unfortunately hierarchy for some reason is disabled in Data Visualization Desktop which is strange given that it has been already discussed in DVD Product document. It would be better if you raise an SR with Oracle asking for the reason of same. Thanks and Regards, Syed Hamd Salman
  • Hi Gabriel, Did some research on your requirement and it doesn't look like you can drill down from a summary of the data to a detailed report - from one visualization to another, but you can drill your data within the visualization based on hierarchy and data element. More information on same in below link:…
  • Hello Shripad, 1) To calculate Last Year Date using date column you can make use of "Add Calculation" at the bottom of the Project 2) To convert datatype of a column you can make use of CAST function
  • Very funny!!...right? @Christian Berg
  • Not sure but don't think protected excels can be uploaded in DVD/DVCS/BICS(VA), just in case you need more information on same log an SR with Oracle Support for same.
  • Hello Aashish, Write Back is OBIEE functionality(see below) not sure how are you "trying to implement" it in BIP? https://docs.oracle.com/cd/E23943_01/bi.1111/e10541/answersconfigset.htm#BIESG1356 Even a google search on "BI publisher writeback implementation" doesn't show up anything. Thanks and Regards, Syed Hamd Salman
  • Hi Stu, Doesn't look like we have a property to resize the bubble in scattered graph in data visualizer, may be ​ can confirm on same. Thanks and Regards, Syed Hamd Salman
  • Hello There, In your VA(Visual Analyzer) Project , place measure column under "Size" section and see if the change in bubble of scattered graph is of appropriate size. Thanks and Regards, Syed Hamd Salman
  • Hi There, The AGGREGATE AT function will work only with hierarchical column, refer to below mentioned blog explaining more on same: https://gerardnico.com/wiki/dat/obiee/obis/aggregate_at Please also refer to oracle document on function "AGGREGATE AT" C Logical SQL Reference Thanks and Regards, Syed Hamd Salman
  • Hello There, Keep checking your email, it might take up hours or even a week time for your trial environment activation depending on demand. Thanks and Regards, Syed Hamd Salman
  • Hello Cesar, Yeah VA project download as CSV isn't available in BICS Visual Analyzer application, you can raise an SR with support if you need this option to be included as future enhancement, but I suppose such a common feature might already have an enhancement. Thanks and Regards, Syed Hamd Salman
  • Hello There, Its pretty late for the response on your query, but will answer anyways as it might help others with similar queries: The only version of RPD that can be uploaded into BICS environment is 354, this version of RPD is created with Administration Tool of OBIEE 12.2.1.0.0 , but even if you have RPD created in OBI…
  • Hello There, In section "Configuring the Data Source Name (DSN)" is your internal/on-premise database. Please note you are setting RDC in order to connect to your On-Premise database. Thanks and Regards, Syed Hamd Salman
  • Check for other mentioned log as well and focus on what Gianni is pointing out What kind of install you did? Did you load the SampleSales Lite BAR file during install? Because if not ... your system is empty (totally empty) and it's kind of normal you can't do anything.
  • Just in case you are using BIAPPS 7.9.6.4(latest and only supported 7.9.x release by oracle) and forgot to mention the same, for same you needed to check Oracle DB 12c certification then here is the document which covers the same. OBIA 7964: Is BIApps 7.9.6.4 Certified With Oracle DB 12C (Doc ID 1995298.1) But if your…
  • Then the right way to go about it would be to check for more detailed error messages in sawlog(X).log and obis1-diagnostic.log, at below mentioned location respectively. <ORACLE HOME>\user_projects\domains\<DOMAIN NAME>\servers\obips1\logs <ORACLE HOME>\user_projects\domains\<DOMAIN NAME>\servers\obis1\logs feel free to…
  • Looks like you are facing issue described in below mentioned Oracle KM Document. OBIEE 11g: Scheduled iBots fail with "No Content for user" (Doc ID 2105577.1) GUID Refresh is suggested for such issues below is link on how to perform GUID refresh.…