-
Anonymous Login Configuration for Oracle Analytics Server
Hi All, environment - OAS 2023, FMW 12.2.1.4, APache web server, Azure LDAP configured for user SSO authentication. I went through the below blog and PDF in it. https://blogs.oracle.com/analytics/post/oas-anonlogin Somehow I missed to understand where we create the user which we want to use for Embedding. where and how we…
-
OAC - AI Assistant
Hello Team, We are excited to use the AI Assistant soon. https://blogs.oracle.com/analytics/post/oracle-analytics-ai-assistant-getting-started-in-3-steps Sep 2024 patch was applied in our non prod env but I don't see the Assistant option when I click on Inspect→ Search. Is there any other configuration needed to enable…
-
Analytics Service Paused by System Admin
Hi Team, Today when we are logging into OAC instance, its giving below messages - Could you please let us know what could be the issue. Regards Saroj
-
Dataflow sharing functionality issue in OAS 7.6
We're experiencing an unusual issue with dataflow sharing in OAS 7.6. While testing the newly introduced dataflow sharing functionality, we found that when a user with full read/write access to a dataflow (owned by someone else) tries to remove the owner's permissions via the inspect option and saves the changes, the…
-
list of the reports from the catalogue that are using direct database request
How can we get the list of the reports from the catalogue that are using direct database request? I have tried using the catalog manager tool for the same, but could not find the exact key word to get the report
-
Oracle Analytics Product Roadmap Q2 2024
New Oracle Analytics Product Roadmap Available for Q2 2024 https://community.oracle.com/products/oracleanalytics/kb/articles/32-product-roadmaps
-
OBIEE 12c Installation Stuck
Hi, I'm Installing OBIEE 12c in production environment, but the installer got stuck after launching , can't either click on Next Button, I did the same installation in DEV environment and went successful but don't know what is the problem here, no error in the log , the environment is more performant than DEV . OS version…
-
OAC Remove Folder SOAP operation failing with Invalid session ID or session expired
Hi, I created a new OAC instance. I am trying to delete a xdo report using removeFolder soap operation. I generate the stub using the wsdl and calling it from an application in java. The session id is valid but when calling removeFolder with recursive set to true is giving the below error. Same stub works fine when we use…
-
List of reports using direct database request
Is there a way to produce a list of the reports from the catalogue that are using direct database request? thanks William
-
Using an BI Subject area as source to Data Flow
Summary Can a BI Subject area be source to Data Flow Content I would like to take data from a subject area and run Sentiment analysis on that. However, the only way i can achieve that is by extracting that data from BI classic (OBIEE) in OAC and the upload the file in Data Visualization. Does any one know if allowing a…
-
Null Values not passing into Presentation Variable When using DDR
Hi Team, I am not getting correct data in report when passing null values in presentation variable via Direct Database request. I have used below expression - (TRIM(t38735.ASSIGNMENTNAME) in (@{V_ASSIGN_NAME}['@']{''}) I am getting all the records from ASSIGNMENTNAME, but the issue is this particular attribute has NULL…
-
RESTAPI in OAC
I am trying to fetch some sharepoint data using RestAPI app in OAC. Do we have any related document? with examples of base url, endpoint url and how to create login credenticals.
-
Timestamp value in OAC URL is getting converted automatically
I have created a data action to navigate from Canvas A to canvas B using URL navigation by using date as anchor data URL looks like <base workbook URL>&p1n=BUCKET_START_DATE&p1v=${valuesForColumn:START_DAY_DATE} the value for BUCKET_START_DATE gets automatically converted to a different value where as I want exact value to…
-
How to customize Dashboard Filter ? (hide / remove Exclude & Null checkbox)
As the user, I should have the ability to customize my Dashboard filter. Please suggest me a way to hide / remove Exclude & Null Checkbox in the dashboard filter.
-
How to apply filter using Parameter attribute for Exclude checkbox ?
Hi I have embedded the OAC Workbook within my website. I need to apply filter via my code by using parameter attribute for "Exclude" checkbox available in the List Filter. I can able to apply List Filter values, Even Top Botton N. But not able to apply the same using "Exclude" though I've created a parameter for the same.
-
Moved: MRP Planning Pegged Quantity Subject Area Real time
This discussion has been moved.
-
Spacer Background themes - Oracle Analytics
Hii…..We want to add some amazing themes/Background in our spacers of Analytics canvas . We couldn't find it , Can anyone provide some urls or resources for this ? To give an idea, something like the image below(Top horizontal spacer theme ) .
-
Call Catalog RestAPI from OAC DV
Is it possible to call the below Catalog RestAPI to list the catalog items from OAC DV connection? https://docs.oracle.com/en/cloud/paas/analytics-cloud/acapi/op-20210901-catalog-get.html I'm looking to build a dataset to publish the report catalog in DV for users to search and find reports that they are looking for.
-
Looking for column package ID (Background Check Services) in Oracle Taleo Analytics/reporting
Looking to report package ID (requisition background check) in the analysis in Taleo Analytics reports. please Help. Please see attached.
-
Moved: Provisioning a New Test Instance with a reliable security matrix
This discussion has been moved.
-
OBIEE 10G - Line Bar Combo: Unable to apply two lines
Hi, Looking at guides and other sources for 10G charts it appears there is a way to apply two lines on a bar chart combo. However, I am unable to see options on what to select as a bar and what to select as a line. It appears the first measure is automatically selected as a line and any other measure after that are…
-
Cannot function ship the following expression: EVALUATE.
When the env is upgraded fom 12.1.1.4 to OAS 7 , some reports are failing due to evaluate function not working. The same report is working fine in OBIEE 12c but not working in OAS 7. Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P. State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058]…
-
Date Format Error (not a valid month)
Hello, I am experiencing an issue with the 'Done Time' column where the day is being interpreted as the month. Although the format in the database appears to be correct, Oracle Analytics Desktop seems to misinterpret it. I have attempted to adjust the format within Oracle Analytics, but the issue persists. Could you please…
-
OAS - SMTP Mail server configuration
HI All, Please share any blog link, high level tips on how to configure SMTP server in Oracle Analytics Server 2023 (7.0) Linux server. We want to send analysis (Excel or PDF) via mail (Agents) to users. does DV visuals / canvas can be sent to customers using agents like Classic BI analysis.
-
How to create a report after creating a BI Publisher augumentation
I have created the augmentation for BIP, i want to know how to fetch the results from warehouse table and steps for the same?
-
How can I redirect http to https for obiee 12c
Hi. We enabled https for obiee 12c. When wy connect to https://xxx:9503 everything is good but when we try connect to http://xxx:9502 it redirect to https://xxx:9502. It is possible to change port automatic?
-
Hi friends, I ask a question about Authentication error
Hi friends, I used BIEE 12.2.1.3.0 ,5 days ago ,my comany restart server. after it ,i restart the Obiee app server .when I login at "http://10.241.*.*:9502/analytics with old user and password" , it tell me that "An error occrred during authentication .Try again later or contact your system administrator". The app's log of…
-
OAS security user folder
Hi All, 1) in OBIEE 12c we used have catalog folder with security folder where all the users will have their own folder (connected to catalog My folder).. where is this folder now located in OAS (2023 0r 2024). is this folder also present in DB schema like other catalog objects. ———2) Also is OAS storing LDAP (configured…
-
Unable to edit and save agents after ownership change
Hi, We have changed owner for a catalog folder including all the items within. The new owner is able to edit/save reports but unable to do so for agents. When trying to edit agents he is getting "Insufficient Permissions" error. Both the users are in same security group and have full control. Any idea whats happening?…
-
Primavera Analytics Map
Good day, We are currently busy creating a GIS Map Analytics/Dashboard for the business. We are in the energy sector, so we are struggling to plot Powerlines, Transformers, & Substations on our current map, we suspect it's because the data has not been captured in Primavera P6. Are there any fields currently that we can…