-
FCCS : Power user security
Hello, In Task Manager, we have an issue with the Power User abilities. We would like to have a granularity of the power user so they can have access to their scope only.
-
Need help in Data Elements display in the report for documentation purpose
Hi , I have a query whether we can display the table or a dataset columns metadata as a report for the end users to show the data type for the columns ? I mean something like this in OAC Report : DESCRIBE TABLE_NAME
-
Restrict access to BI Publisher only for App role
HI All, In OAC environment is it possible to create an application role similar to BIServiceAdministrator, which can only access BIP URL. no access to Classic BI analytics and DV. we like to restrict access to current Dev/admin team who are developing analysis in Classic BI Analytics. TIA
-
OCI streaming - message filter & best practices
I am looking to implement OCI streaming in the integrations we have in OIC platform. My concern if in a multiple public-subscribe model, whats the best practice around how message selection is done if we have a single publisher and multiple subscribers? And also, if future new subscribers are being onboarded, would it be…
-
Error in fetching the data from OAC using soap request
I was trying to fetch data from OAC using soap request for 1M data in batch of 50k. upto 5-6 lakh data is fetched properly but after that throwing an error Error: soap:Server: Assertion failure: !rState->getCursor().isNull() at line 246 of project/webviews/rsxmlserializer .cpp: {"Error":{"Code":"ACIOASLN","Message":…
-
Errors on reloading any [database] dataset in OAS 2024 ( 7.6)
Hello, I've installed OAS 2024 on 3 Windows Servers (2022) with OraDB19c as Repository-DB and on all 3 systems the reload of the simplest dataset is raising an error - the funny part is - it looks like the data are really "refreshed" and reloaded, but the status is failed and the log show internal errors. Since the error…
-
Incremental load through dataflows in Oracle Analytics DV 7.6
We currently receive incident extracts from ServiceNow via email in xlsx format for all incidents in our departments and manually upload these extracts into Oracle Analytics datasets. These datasets are then used to visually represent some key department metrics in an Oracle Analytics DV 7.6 workbook. We are now planning…
-
OAS clustering port config
For OAS, in a horizontal cluster the default port set for bi_server2 for ssl channel is 7503. We need to use the same ports like 9503 used with SSL, for both servers bi_server1(9503) and bi_server2(7503) due to the use of Load Balancer. When we change the port of bi_server2 to 9503, the login is successful but session…
-
Traverse permission access to folder
Hi, I have a requirement to grant access to a user with X role to a specific report within a folder that only grants access to users with Y & Z roles. An example is: /shared/Custom/Company/Reports/Finance →"Sales report"(report entity) I've granted Y & Z roles "Open" permission (Read, Traverse) and X role "Traverse"…
-
Using Line _ Bar Combo graph in OAC Classic Home
Hi Experts, I have a requirement to bring Line & Bar combo graph for one of our report , whereas on using Line Bar graph in classic home, All Actual graph are displaying first followed by Budget & PY Actual, Line graphs are not even showing in the report. have attached the expected report vs current report. Pls guide me…
-
Complex Calculation - unable to fulfill in OAC RPD Client Admin Tool due to its limited functions
Hi Team, I am having a calculation given by ETL folks, which I am unable to achieve in OAC RPD Client Admin Tool due to its limited functions. Can you pls assist here as how can I fulfil the need in RPD. Calculation: Dunning_Level: CASE WHEN NVL(FLOOR((TRUNC(sysdate) - TRUNC(TERM_DUE_DATE))),-1) < 1 THEN 0 WHEN…
-
Deep Links from OAC classic BI to Fusion Requisition/ Candidate(Oracle Recruiting)
Hi, Our Business users want to have deep links from OAC Classic BI report to Oracle Recruiting Requisition or Candidate details page. Is it possible to provide deep link from OAC? We know it is possible from OTBI, however we would like to have it from OAC as well. Kindly let me know if there is any doc or link related to…
-
Errors with FORECAST and Outliers Functions in Oracle Analytics Server
I am encountering the following error: "Error during query processing (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS [ecid: ts:2024-12-30T12:26:51.565+03:00]. (HY000)…
-
OBIEE to OAC BI Delivers agents scheduled time incorrectly sets to UTC
When OBIEE 12.1.x to OAC migration is done, the BI delivers agents migrated from OBIEE which ran on EST time zone server, run in UTC in OAC (5 hours earlier incorrectly). TO give an example BI agent in OBIEE in EST server ran at 8 am EST, now in OAC runs on 3 am (8 am UTC) incorrectly. What is the resolution to fix this…
-
Analysis & Workbook Edit|Save
I have are that restricted to edit the OAS Analysis but save into the same location. This will open My folder to save it. But DV doesn't have the same feature that Analysis offer. Permissions wise , DV only gives us Full access to Edit/Save or just view (from Workbook Inspect ) . I tried on Catalog permission from OAS…
-
Creating a Calculation that Ignores Filters in OAC
How can I create a calculated measurement in DV omitting some filters? I need to add a field called BUDGET and I want the calculation not to be affected by some filters. In power bi they use this function CALCULATE(SUM('BASE'[BUDGET]),REMOVEFILTERS(BASE[Exclude_filters]),'CALENDAR()'[Month]) In Qlik sense they use this…
-
ORACLE BI Aanalytics Cloud | Login Issue [Critical]
The Oracle R&A system has been experiencing a critical issue involving login failures for over two weeks. Despite multiple escalations, the problem remains unresolved, causing significant disruptions.
-
I require assistance in resolving the GEN3 error.
I am receiving the below error in GEN3 environment when i run the integration (RSI Common OUT BICC Export To AWS Integration) : Error while reading and skipping native data. [Line=2, Col=151] Expected "${eol}" at the specified position in the native data, while trying to read and skip the data for "schema", using…
-
Oracle Analytic Server 2024 Installation - Configuration Fails
Hi, I am installing Oracle Analytic Server 7.0 on linux. On running the config.sh file in bi/bin/, I am getting the error below.
-
Oracle Analytics Mobile App is disconnecting or requesting for authentication
Dear Team, I am successfully connecting Oracle analytics mobile app with FDI URL. after logging into the application while navigating to one one workbook to another workbook it is working as expected seamlessly however, when I do the navigation from one dashboard to another in the custom-built dashboards, it is asking me…
-
how to create a hyperlink for a specified column values in the dataset
Hi we need an option to have the hyperlink creation of the specified column.
-
Why it is so difficult and so confusing to have different color in different graph for same measure?
-
Unable to use filter by parameter selected year - 1
I have created parameter using date - year. Trying to create below calculation to put it as parameter for one of the table for previous year. E.g. when choosing 2024, the table will then be filter by 2023 and so on. However, error is prompt. Could any expert help? Thank you.
-
Oracle Analytics Cloud - Is OAuth Access Token usage supported with SOAP API
We use username and password parameters with logon method to get session id and then subsequently SOAP calls are made using this session id to perform necessary tasks like get catalog item info. We do have a requirement to support OAuth token (Resource Owner or JWT assertion) for this process. Is it possible to use OAuth…
-
Issues Setting Up Azure DevOps Git repository with OAC Modeler
I am attempting to integrate my OAC Semantic Modeler with Microsoft's Azure DevOps Git service. I have set up a DevOps project and created a repo. I use the following URL to clone my repository to my model: https://xxx-xxxx.yyyyy.zzzzzzzz/xxxxyyyzzzzzz/OracleBI/_versionControl?path=%24/OracleBI/test.git I receive an…
-
Detail about Machine Learning model in dataflow
May i know the detail regarding the Train numeric prediction in data flow. like : What is minimum node size means? What is maximum Depth means? What is Maximum confidence means? What is Train Partition percent change going to impact to? What is Balancing method under sample, over sample, none explanation?
-
How to use session variable in connection script
I have created a connection to an Oracle database, with Basic connection type. I have also created a Semantic Model using this connection. In the connection pool settings, I have defined the following "before query" connection script: insert into test_login_log(txt) values ('VALUEOF (NQ_SESSION.USER)') This inserts the…
-
Issue encountered after changing ownership (from one user to anther user) in OAC object.
Reference Oracle SR - 4-0000038368 Post changing of all OAC object's (DataFlows, Datasets) ownership to a new user - NEW-USER, old user - OLD-USER was made deactivated. Consequently, all OAC objects have stopped working. Root cause => Scheduling part of all objects (Dataflow, Dataset etc) are not working. Temporary…
-
Can't find Data Connection from the create Data set tab.
Hi Group, When I create a Dataset from the OAC homepage, many of the Data Connections I previously created do not appear in the list. I’m not sure if this is due to security settings or if additional configurations are required. Could you kindly assist? Thank you!
-
Dataset Modified | Local Subject Area
Greetings Community, there have been a modification that has been made on this Local Subject Area (in OAC): But the problem is, all steps in the making of this dataset remains as-is: So the question/concern is, what exactly the change that was made 5 days ago? Thank You in Advance for your time and efforts :)
