Skip to main content
41 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
17 views

I have a dataset that contains a username column. I want to filter BI visualizations automatically based on the logged-in user in Oracle Analytics Server (2025). How can I implement RLS (Row Level ...
morteza KHORSAND's user avatar
  • 1
1 vote
0 answers
66 views

Just found out that when i imported an OBIEE analysis with 20000+ rows to a BI Publisher data model. After create report and export out result. There are data missing. Remark: For analysis, export ...
Ka Yuen Hung's user avatar
  • 11
0 votes
1 answer
2k views

We are using Oracle Analytics Cloud. I have admin role. But i can not see physical sql in session log. I can see logical SQL and query run stats etc. I checked sesion log - it more or less look like ...
Koushik Roy's user avatar
  • 7,439
1 vote
0 answers
62 views

Before Saving After Saving In Oracle Analytical Desktop, I am using Variable Prompt (Custom Visualization), After saving my canvas the dropdown values of Variable Prompt Disappear .Only the selected ...
Wajahat kayani's user avatar
  • 111
1 vote
2 answers
201 views

I need help to write a query in Oracle to get minimum value for each row, comparing the current row amount with the previous minimum value. In another word, calculate minimum value for each row from ...
Ash020292's user avatar
  • 29
0 votes
1 answer
110 views

I am actually trying to make a matrix table using Oracle Analytics tool and PL/SQL. Let's say i have a query which has in select statement variables Employee, Description, orderid ,amount and is ...
Andrew's user avatar
  • 1
-1 votes
1 answer
87 views

The issue is i have a catalogue of reports that have security policies assigned to them. Let's say things like 'manager' can access this report, but not this. This goes on throughout the catalogue. I ...
sagan cobra's user avatar
  • 1
1 vote
1 answer
117 views

I need to number the rows so that the row number with the same ID is the same. For example: Oracle database. Any ideas?
Vilius Gaidelis's user avatar
  • 450
0 votes
2 answers
406 views

I am using the RPD tool to create a data model for a database which has 6 tables. Dimensions : ProductFamily, ProductionLine,Company,CurrencyExchange Facts: WorkOrderStats, WorkOrder But, WorkOrder ...
Equalizer's user avatar
  • 47
0 votes
1 answer
358 views

OAC ADW = Oracle Analytics Cloud Autonomous Data Warehouse. Our OAC ADW admin provided us .zip wallet files for connection, however this is not natively supported by DbVisualizer. How can I make the ...
Frank Wang's user avatar
  • 431
0 votes
1 answer
785 views

we are creating a pivot table in OBIEE, we need to hide columns from the pivot table if those columns are null. Is there any implicit way of doing this in Oracle OBIEE? Thanks in advance
Raghu R's user avatar
  • 23
1 vote
0 answers
269 views

I have a problem while I'm trying to import a .dva file generated from Oracle Analytics Desktop into Oracle Analytics Server. It speems that it doesn't come from any specific dva file, it happens with ...
Adrián Lamela's user avatar
  • 11
10 votes
3 answers
1k views

I´m tring to make a query with a conditional SUM. The SUM needs to get more than 15, after that reset it. Like this: A | 3 | 3 B | 7 | 10 C | 6 | 16 -- ==== D | 5 | 5 E | 9 | 14 F | 3 | 17 -- ===...
Fábio Almeida's user avatar
  • 296
2 votes
1 answer
89 views

How should I use the analytics to give me a rolling average where the sample size changes? create table MyVals (Item_no char(10), epoch number, Yield number, Skip_Period char(1), Reset_Period char(1)...
lidbanger's user avatar
  • 167
0 votes
2 answers
125 views

How can I split a string by comma using oracle sql? Here I have a column which has values like below 123Lcq Lf32i jkp32m I want to split it by comma 1,2,3,L,c,q L,f,3,2,i j,k,p,3,2,m
Ronnie Lu's user avatar
  • 9
1 vote
1 answer
1k views

I have a below query : select id, firstname,LastName,Company, dense_rank() over (partition by company order by id ) from UserAdditionalData where Company is not null Here is the result that I am ...
Ashwani Kumar's user avatar
  • 21
-2 votes
2 answers
46 views

I need to fetch the sum between bal and res columns for each different account (acc) using the max(timestamp), look at this: ID ACC BAL RES TIMESTAMP -------------------------- 1 100 70 0 ...
user3299544's user avatar
  • 1
6 votes
5 answers
5k views

I need help writing a aging report on oracle. The report should be like: aging file to submit total 17 aging file to submit 0-2 days 3 aging file to submit 2-4 days 4 aging file to ...
JavaSheriff's user avatar
  • 7,741
1 vote
1 answer
222 views

I'm dealing with this particularly complicated (to me at least, if you're a math geek, don't you judge me!) issue. I've essentially got two things a record of what current stock levels are and a ...
user avatar
1 vote
1 answer
9k views

I want to join my CHEESE table with FRESHNESS to get CHEESE and FRESHNESS code for cheeses where max(seq_no) for each cheese id is MOLD. When using rank(), where do I join to FRESHNESS? CHEESE ...
zundarz's user avatar
  • 1,594
4 votes
3 answers
7k views

I believe the Oracle function FIRST_VALUE is what I need to be using based on these two questions: SQL - How to select a row having a column with max value Oracle: Taking the record with the max date ...
Paul's user avatar
  • 20.2k