You need to look for this

rpd is not a db client tool to know your sql queries. You have to tell what is what about columns and tables to the rpd This is what I said do manually in very first response!

Check this OBIEE - Integer Datatype [Gerardnico] this explains why it does!

You need to do any of these 1) use column names in the query like select Name, fst_name from ARSchem.ACCOUNTS or 2) After created as you have done as in Point# 6, just add a column manually to the object ex: Name and then go for "view data"

Local path: OFM\Oracle_BI1\clients\biserver

Check this Oracle Business Intelligence Downloads

Passing Prompt's 'All Column Values' or 'All Choices' to Presentation variable When we are using Presentation variables, Prompt functionality is very limited. One of those is using option 'All Column Values'. Here I'm trying to depict a Tip to make use of option 'All Column Values'. To demonstrate the same here I'm…

Use the below statement for the Filter by Convert to SQL. U as Presentation variable name <COLUMN> LIKE (CASE WHEN '@{U}{}'='' THEN '%%' ELSE '@{U}' END)

In my case Using Administrator link after login shows as Oracle BI Publisher 11.1.1.7.0 (build:20130303.1415) Login page shows as Oracle BI Publisher 11.1.1.7.0 So best place to check Using Administrator link

You need to do something similar to cool-bi.com *** Moderator action (Timo): @Srini VEERAVALLI according to the posting guidelines you should not just copy a link, which might have the right answer, to answer a question! Write the answer directly to the thread providing enough useful information directly in the body of a…

Check this InputStreamLimitInKB tag in https://docs.oracle.com/cd/E23943_01/bi.1111/e10541/psconfigset.htm#BIESG103

The action is like renaming existing object. There wont be any impact. If need use check box for preserver old reference.

In the rpd go with 2 columns 1 for Sales which goes to dimension and other one is for sum(sales) which is for Facts in Presentation in the report use accordingly

If i'm not wrong no need to do any changes. after db upgrade try to start bi services and see how thats working.

check this https://docs.oracle.com/cd/E21764_01/bi.1111/e13880/toc.htm You need to work with file from OFM\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Admin\Configuration\xmlp-server-config.xml

login to <yourhost>:9704/xmlpserver with Administrator/Administrator and then configure security tab etc https://docs.oracle.com/cd/E23943_01/bi.1111/e22255/intro.htm#BIPAD109

Check this link might give you some directions OBIEE GURU: OBIEE Data Level Security - Session Variables

I would say handle NULL values for that particular column. also check this Doc ID 1639419.1

I guess thats good. just in case check this cool-bi.com

Try this localhost:1521/orcl