-
Getting coredump and segfault error on sawserver in OBIEE12c
kernel: sawserver[87624]: segfault at ffffffffffffffc8 ip 00007ff8fbd43720 sp 00007ff89e47dd08 error 4 in libsawcatalog643r.so[7ff8fbc13000+321000]. Has anyone faced this issue?
-
OBIEE-Prompts
Hi, We have a requirement to create prompts based for financial year. Eg: We have two prompts prompt 1 and prompt 2 on date columns.If we select value for prompt 1 as Apr-16 then prompt 2 should display the values from May-16 to March-17(i.e it should not display the selected month value of prompt 1 in prompt 2) and prompt…
-
How to retrieve a value based on a date selected by the user in OBIEE
Hello Oracle Community, I have been investigating about how to retrieve a value based on a date selected by the user in analytics, for instance, let's say that the user has selected the date 01//31/2017, I would like to know how can I do to retrieve a value based on that date. I know that I can use a dynamic repository…
-
prompts take long to load
Choice list prompts can take minutes to load if the table is large enough (even dimension tables), and can cause a script error and not run at all. In this case report is unusable. Note: When in analysis, the filter returns the list immediately. This issue is seen when using the prompt from the prompt tab in the report and…
-
can I set a presentation variable with the results of a direct database request ?
Hello OBIEE Community, I wanted to know if is possible to set a presentation variable with the results of a direct database request? I mean, if I can fill the presentation variable in analytics with the results of a query made directly to my oracle database. If so, how? Apart from this, How can I filter this direct…
-
Cache purge not working
Hi, OBIEE 12c even though I use the function call SAPurgeAllCache() , my OBIEE dashboards are showing old values. Once I do the dashboard refresh, I am able to see the updated data. Can you please help me on this. Thanks Mahesh
-
How to hide Data Markers dynamically
Hi, I have a requirement to show or hide data markers on OBIEE Graphs dynamically controlled by a prompt on Dashboard. One way of doing it is creating a 2 graph views one with data markers displayed always other hiding them and flip views using conditions in sections. I am looking for a simpler option. Any such thing…
-
How do I multiply the results of a column from one analysis with a result of a column from another a
Hello For technical reasons, there are two columns I can't have in the same analysis. However, I need create a column in another analysis that multiplies the two values together. I have gone to the 'Edit Column Formula' diaglog but I cannot figure out a way to pick the results of the other analysis. The column itself in…
-
Differences between DV/VA and Answers
Hi all, Would really appreciate if someone could share their knowledge around the differences between DV/VA and Answers. I'm struggling to find anything on this on the net. Looking for functionality differences/software differences. Things I can do in Answers that I can't do in DV/VA and visa versa. I'm trying to run a…
-
BI EE 11g analysis graphics Y-axis scale factor
Hi All! I created BI EE 11g analysis. And in graph i need to chande scale factor, see picture: What the parameters i need inserted in XML code and where? Thansk!
-
Last modified date in obi for user build query
Hi All, In general, we have catalog and we can go and check last modified date over there, But here my question is how can we know last modified date for user build query. when we checked it shows all the folders same date. Can any one help me out of it. Thanks, Chandrababu M
-
BICS: Is it possible to change data model in existing report (how to change old report data model).
Summary BICS: Is it possible to change data model in existing report (how to change old report data model). Content Hi How to CHANGE DATA MODEL in existing report!! Example: I need to develop Same Dash board with multiple sources. 1) I have a report 'A' by data model 'X'. 2) I developed a new data model 'Y' with different…
-
How To Display The Employee Image Stored In The Database In XML Report
Summary How To Display The Employee Image Stored In The Database In XML Report Content I am using XML Reports with RDF my sql query is in rdf is select xxx_getbase64(image) from per_images where parent_id=:p_person_id FUNCTION xxx_getbase64( p_source BLOB ) RETURN CLOB IS v_result CLOB; BEGIN…
-
Using a reference to an external .jpeg in a RTF template
Summary Using a reference to an external .jpeg in a RTF template Content Hi, I am trying to use this url url:{'/ora/${TWO_TASK}/AP/CheckSignatures/TestSignatures.jpg'} in association with an image in a RTF document template (Format --> Size --> Alt). However it seems the url string is not evaluated correctly and testing…
-
BI Publisher
Summary BI Publisher Content When viewing the BI report, they were told they could use CTL F to find a value. That didn’t seem to work when they were trying to search a value that was on the page (as a test). They were viewing checks and attempting to find an employee.
-
OBIEE Event Polling table not getting updated
Hi, I have event polling setup with our 11.1.1.7 version, after the upgrade to 11.1.1.9.16 event polling table are not getting updated for the "Other reserved" are not poulated hence the caches are not cleared, any insight?
-
How to retrieve a value based on a month selected by the user in Analytics?
Hello Oracle Community, I have been investigating about how to retrieve a value based on a month selected by the user in analytics, for instance, let's say that the user has selected the January, internally now I am converting this to its last day 01/31/2017 (January = 01/31/2017, February = 02/28/2017 and so on), I want…
-
OBI Agent email missing for Agent Subscribers
Hi All, Issue : users who are subscribed to an agent is not receiving emails. If we add the same user as direct agent recipient, he receives the email. Version : Oracle Business Intelligence 12.2.1.1.0 Authentication : MSAD. User email is defined in Active directory Agent Setup : In the Agent Destination tab, we selected…
-
SQL Sent to Database Does Not Include Filter Criteria
Upon investigating long query times, I noticed the SQL being sent to the server does not include the date filter provided in Answers. This results in the query run on the database to return all rows, then the result set is being filtered at the BI Server. While the end result is correct, the production database has…
-
OBIEE Deployment
Hello, We are migrating OBIEE RPD and Catalog from one Server to another Server (this is not from Dev to Test or Test from Prod, it is from Server 1 to Server 2). We have several folders, sub-folders in our catalog along with several MyFolders (there are over 20,000 users). We have the same Catalog folder structure in…
-
How to get DBCS details of BICS trail Subscription Account?
Summary How to get DBCS details of BICS trail Subscription Account? Content Hi Team, I have recently signed up for BICS trail subscription .The domain is : incapgeminitetrial I would like to do RPD Lift and Shift and would like to point my RPD to DBCS. How would I get to know the below information of my Trail Account: *…
-
Mobile App designer not opening
Hi, We have configured OBIEE Mobile App following the instruction document. OBIEE version is 11.1.1.7.150120 and we are accessing OBIEE from Oracle EBS using SSO. Now we can see the icon when we log in as admin user. However, it shows below error when we click on Mobile App Any thoughts on possible reasons? Regards,…
-
Are prompts available in Data Visualizer?
Hiya all, I've been using Answers and am looking to switch over to Data Visualizer and I am wondering if DV has the option to use prompts like Answers does. I can't seem to find anything, but I could be looking in the wrong place! I am able to find information on the conceptual differences between the two tools, however I…
-
OBIEE 12c - LDAP config
Hi, Most of the blogs/documentations I've read utilizes an external LDAP such as MS AD for users and groups. I'm wondering if anyone setup their OBIEE by utilizing users from AD, but creating groups in Weblogic. This way, you don't need to wait for another team to add/edit the groups. Thoughts?
-
Oracle BI EE analisys format number
Hi! I create analisys and when create the totals field, I can not create a custom number format: see picture
-
Regroup and Filter Data Regardless of the XML Source
Summary Regroup and Filter Data Regardless of the XML Source Content Hello everyone, I am stuck with a RTF template I want to make for JDE I am trying to create a customer statement in XML from the standard R/E Customer Statement R155001, so if anyone used in the past I would really appreciate any help The problem is the…
-
How to hide tables in Oracle BICS Modeler
Summary How to hide tables in Oracle BICS Modeler Content Hi all, Can anyone please tell me how to hide table in Oracle BI Cloud Service Modeler. Thanks.
-
CLOB in XML giving unhandeled junk characters
Summary CLOB in XML giving unhandeled junk characters Content Hi, I am working on quotation module. Reports picking the data from CLOB datatype and showing in pdf ouput through xml publisher. Due to clob data type xml is showing in junk characters which we cannot handle. apart from special characters xml tags are showing…
-
DVCS - data set from OTBI
Summary DVCS - data set from OTBI Content Folks, I am somewhat new to DVCS and have question. We can create a connection to OTBI in Data Sync where the connection type is "Oracle BI Connector" and the URL in my case is: xxx.xxx.us2.oraclecloud.com/analytics. Then we can have an analysis in OTBI show up as a data source in…
-
Display static result based on dynamic data
I am not sure if the subject make sense but here is what I am trying to accomplished. I created an analysis showing ranking data for example NameSales %RankingJohn90%1Peter80%2Joe70%3 But then I want when Joe logs in and run this analysis to see ONLY his record and see that he is #3 Or create another analysis that can be…
