You don't have to start from scratch, when you go and deploy your migrate 11g things it will replace everything related to the SampleApp lite you deployed first time (it will not merge them or anything). There is a command line tool you will call that replace the Sample app lite by your migrated content. So you don't have…

Do you really see that in the physical query? Because that doesn't sound like the normal behaviour .... A data filter set in the RPD is always applied and must not be overwritten by "all values" (what's the point to set it if you can get rid of it so easily?)

Well, probably a inner join filtering .... Selecting "all values" I imagine remove the filter completely => maybe that dimension isn't used at all => no inner join implicit filtering. Selecting all the values one by one will change the query => different data. Can also be because of a different set of tables used if you…

As a side note .... OBIEE 12c isn't certified with Windows 2008, only with Windows 2012 and 2012 R2. So if at some point things doesn't work anymore .... will be difficult to get any official support ...

Hi, Did you check the properties of the column to set the number of "decimal places" to something else than 0 ? Because by default all the measures are displayed as numbers without decimal places. Not seeing the decimal part doesn't mean it isn't there PS: it's in your analysis, column properties > data format > check…

Hi, I had to read the previous posts twice to find out if I was dreaming or I saw it correctly .... cesar.advincula.o wrote:Could you do AGO/TO_DATE in OBIEE without a Dimension Time? Is a quite difficult right? No, not really difficult, actually lot easier than building an OLAP cube. Repeating myself: you simply model it…

Well ... Not sure how do you want to use a CASE STATEMENT for that as it's row by row ... So it's more something you can achieve by filtering your analysis ... Like if you add filter on YEAR = 2016 and MONTH IN (Jan, Feb, Mar, Apr) and you don't add the "Month" column in the analysis you end up with April YTD figures, but…

Hi, Without a time hierarchy in your business model forget the OBIEE timeseries functions, they can't work. You can simulate the same result by modelling things differently to generate a YTD or things like that. So the question is more : why don't you want to tag a dimension as time? It makes no sense to talk about…

Did you remove authenticated user from BI Consumer app role? And why do you keep the default roles if you don't use them? As said this morning: setup your security correctly! If you don't use at all the default app roles and you defined all your owns then delete them (mainly if you don't look inside to see which one…

Hi, I have the feeling you just have a problem with your logic .... It makes a lot of AND and not a single empty / default value managed. If your presentation variable don't have a value they actually match only the rows of your tables where the values are empty, and all the conditions are linked together by AND, so it's…

Please avoid double posting ! Restrict LDAP users and shld allow only if user exists in external database tables obiee11g (actually maybe triple posting with Needs to allow login to the LDAP users, only if he exist in external database tables in obiee11g )

Look at the link rmoff posted

Chris Arnold wrote:Unfortunately, the above does not work. I get an error.This also returns an error. First would be easier if you also post the errors you get as it avoid people to guess it .... Going back to your filter: upper("Location"."Address") IN (upper(@{vAddress})) Did you try adding ' ' all around @{vAddress} ?…

Take what Thomas did, use a pivot view instead of table, add months as columns and keep years as rows => done

I would say Thomas already said most of it ... Your source isn't the best you can have, mixed granularity in a single table is the worse to use in an analytical tool like OBIEE generating queries on the fly if you don't model it right. So following Thomas advice you must model splitting the multiple granularity into…

+1 Christian But you can still edit the table opening it from the bottom-left part of your result tab screen where you have the list of all the views included in your analysis.

Hi, Just click on "Define Parameters" in your action link and set the parameter pointing to your column.

Try to replace DateNumber with CAST(DateNumber as VARCHAR(8)) or something like that making this number a varchar ...

You must manage the null : like adding a CASE WHEN all around to not execute that formula if any of the parameters are null, or manage it by setting a default value if null.

What is the type of your columns DateNumber, age and birth_date ? (the OBIEE type) And can these columns be null ?