Below type ... It has multiple SQLs , so i cannot create SQL type. Couldnt find it in 12c

We have to migrate to 11g first then to 12c. That is why we were thinking of developing it in 12c than migrating from 10g ->11g ->12c

what is the table size in database ? May be the result set you are getting quickly from database cache. check the query cost. If it is low , then next possibility is network connection between your bi server and database server. Run the full query in database including "WITH" clause. Or post your query here

But your action link is missing.

instead of NULL keep 0 and set aggregation field as sum/average. Also in the results change the aggreation rule

Hello, Which version of obiee . in 12c you have option to select the sesson variable in action link

in the advanced tab of your report enter in Prefix part SET VARIABLE DISABLE_CACHE_HIT=1,LOGLEVEL=2; Click apply.. Run your report again. go to administration ->sessions and check what is the physical query generated there .

Best way is to use the time dimension and populate it in a field.but if there is no other go use substring function and concatenate to make desired format

try below formula (untested) Select timestampadd(sql_tsi_day,-dayofmonth(CURRENT_DATE),timestampadd(sql_tsi_month,1,CURRENT_DATE)) FROM "YOUR SUBJECT AREA"

Usually variable names shouldn't have any space in between its name ..although not tried yet..can you try myvariable instead of my variable. Also you cannot use a request variable with @ .it should be referenced with nqsession.variable name

Hello, If it is modelled in rpd and new table is from the same data source and structure you just need to rename your physical table. It will automatically map to the bmm and presentation tables

Hello, In enterprise manager you will find option to change it to display in to option. Go to the bidomain and find where you configured your SMTP details .check the addressing method

Windows i am not sure. But in aix it resolved after adding UTF -8 Font and making it default.

Instead of installing it in windows 10( I think it is not certified yet) download a sample app and try it. https://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

Hello, Try below formula for finding SLA period. Also you can use dayofweek function if you need. CASE WHEN (Hour(create_date )+cast(MINUTE(create_date ) as double)/60 BETWEEN 8 AND 18) AND DAYNAME(create_date ) IN ('Fri', 'Mon', 'Thu', 'Tue', 'Wed') then 'SLA Window' else 'Non SLA Window' END Thanks Aj

not importing any BAR file. it is a clean fresh installation

Name is null error in createdefaultseviceinstance.out Aug 30, 2018 10:08:17 AM oracle.bi.servicelcm_v2.legacyimpl.LegacyPodImpl createServiceInstance SEVERE: [LEGACY_API_PROBLEM_CREATING_SERVICE_INSTANCE] Problem creating Service Instance via legacy API: key=ssi; owner=weblogic; options=CreationOptions…

Fresh installation

I think default will be the lowest level which means No Access though i dont remember it clearly. But why cant you set up object level security in catalog, so that it will not be visible at all rather than displaying just the report name?

Why not cache the report or source table for the time between agents. say if you are running the agent daily keep the cache for the objects for a day or 20 hours.