Hi, There are few options ... BVT has been developed to help during migration but it's good for testing regression as well. If you look into SampleApp there are also scripts parsing objects and returning errors etc. So you have tools provided to help you with these tasks.

Ideally you must correct your model to have the PO Amount with the double meaning: measure in your fact table with a SUM aggregation and in the same time also an attribute without any aggregation (a degenerated dimension exposing the PO Amount as attribute). Plan B you can change the aggregation to Average, it's probably…

Hi, Open the repository, take your warning and fix them one by one .... Difficult to be more explicit when you have something as precise as "Logical column 'a' does not have a valid data type." or "The logical tables 'dimension' and 'Fact' connected by logical join '"Relationship_2004:40367111412380694"' have no…

+1'000 Christian Wij wrote: http://toshiba-pc:7001/analytics Only a simple install deploy Analytics on port 7001 in 11g. It's not advised for any real life usage but mainly for testing because it take less resources not having the managed server. (So less RAM and a bit faster to start)

Interesting that you didn't mention the official documentation ... It's actually the place where to look for details on how to install etc. As you are really new to all this I would suggest to get a training, that's the easiest way to start ... If you really want a book the official Developer Guide is maybe better…

Hi, Is this really something new? Because it's exactly the same as what you posted here: OracleBIServerCon is Down So close the other one or this one, choose one and close others without mixing topics. Looking at the other post it looks like the full life of your install is just moving issue with things working and not…

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