https://community.oracle.com/tech/apps-infra/discussion/comment/16784356#Comment_16784356 Thank you for the response. The model is a simple star schema. also, I'm only pulling fields from one table. May I know what are the other settings you mean? I got the query from the Admin tab. @User_IP06I Select ID, NAME, DATE from…

Thank you Both for your valuable inputs. We have decided to use alter session set NLS_COMP=LINGUISTIC as Execute before query with in the connection pool in RPD. Seems like this resolves the issue we have.

Oracle is our database which I think is case sensitive. I came across this Blog which talks about the similar issue in OBIEE 10g. https://shivabizint.wordpress.com/2010/11/04/enable-case-insensitive-search-in-obiee11g/ We tried to follow this approach but when we are restarting the services it is throwing the below error.…

Thank you for Your response Gianni. Yes, I need to enter the filter values in the Criteria just like in the Image below. Database will have the values stored as JOHN and JENNY but users want to see the data even when they enter it as John/Jenny or john/jenny. Using Search option right next to Value box and searching for…

@Gianni Ceresa @Christian Berg Any thoughts? You're the two people i see in this community who can answer any question. Can you please Provide your inputs?

Is There any alternative work around for now, as it takes time to change the ETL.

Thank You for the response. CASE statement or IFNULL will solve the issue for this scenario. However, this issue isn't just confined to the Gender Column. I've many columns in different tables which have Null Values. So, It's won't be a good idea for me to ask the users to write a case statement when doing self service.…

Forgive my ignorance. I'm kind of confused. 1. Do I have to Join the two facts in Physical layers? ( I suppose Yes) 2. Do I have to Have all the measures in Logical fact and Join that with a Logical table which has header and detail as LTS. Then create a logical dimension with Total, Header and Detail levels and assign the…

Thanks for the response. Let me summarize what I understood from your answer. 1. Create a Logical fact with Multiple LTS. i.e. one LTS is Detail Fact and the other is Header fact. 2. Create Logical dimensions for both Header and Detail table attributes. Then set the Hierarchy for them for respective Measure columns. And…

Yes, I'm aware that OBIEE doesn't work with SQL query. I don't have the SampleApp unfortunately.

Gianni, Thanks for replying. What You said is true. Prompt section of the views reduces the set of data. Here The same way I want to have a prompt which will reduce Data set of Pivot table and Graph at a time. Inline prompts can't be displayed in Results tab, right?

Thanks For the Response.

So You suggest Creating a Logical dimension and Logical Fact with the Same Physical Alias, right? And I've couple of other question in this scenario. Let's Say For Fact A we created a Logical Dimension (Degenerated) and moved all the Descriptive columns into it. My questions Here is 1. Do We have to Join the Logical fact…

Thanks for the quick response. However I tried the pen and paper thing before posting this. It's pretty much straight forward if they had the measure in facts. To say exactly, they are degenerated dimensions in a fact. Let me be more clear. Let's say A is a conformed dimension. B is a Fact1 and C is a fact 2. I joined A,B…

This is not my personal Computer. I didn't even find the OPMNctl.bat File.

I Updated the pic, Please take a look. I'm able to access the Schema and tables from SQLDeveloper with the same credentials.

It worked. Thank you.

3 GB RAM and CPU 4

I'm using windows 10. I installed it with the help of instructions in deployment guide you've provided in the comments above. Oracle virtual box Version 5.2.0 r118431 (Qt5.6.2) is the VM i'm using.

Hello Gianni, Thank you so much for your inputs. I installed Oracle virtual box manager and configured it according to the deployment guide. After that when i try to Start DB & BI it is unable to start some servers. I'm posting the command prompt output below. Can you take a look. SQL*Plus: Release 12.1.0.2.0 Production on…