Please don't double post: Installation of OBIEE 12c in linux centos vm Because now you have 2 threads for the same issue and instead of having the benefits of the community work you split resources in 2 ...

Well, there are many ways to do what you describe, and you also don't need a table with all the dates if you don't mind the holes when nobody has been hired or terminated at a given date... And you must also have a table named S_ETL_DAY in the system schema the rcu created when you did the install and that one is quite a…

Hi, Are you asking how to do it in practice (add a logical table, add an hierarchy, make it a calendar dimension) or you just ask for a table containing .... dates?

Yeah, they skipped the first 12c releases for OBIEE .... If you got all you were looking for you can maybe close the thread? Actually it's still This question is Not Answered.

Hi, OBIEE 12c require FMWH 12.2.1.0.0 at least and comes with Weblogic 12.2.1.0.0 by default. So 12.1.3 isn't supported ...

Hi, Did you try to just get your time as a varchar? Because to achieve what you look for you must get rid of the date component and keep only the time (or transform the date to always be the same date), so in OBIEE you have the HOUR function returning you a number between 0 and 23 and you can then format it looks like the…

As you can create a chart without the issue why don't you just compare for a same chart the migrated one with the newly created XML? You will be able to identify what is different and maybe find out it's just an attribute or 2 in the XML and a search/replace in the catalog will fix your issues.

Yes ... If you have a fact table FactSales with some filters and 2 dimensions: DimCustomers (without filters) and DimBusinessUnits (with some filters as well): - Selecting just FactSales and DimCustomers will not apply a single filter of DimBusinessUnits - Selecting just DimCustomers will not apply a single filter at all…

If you want to continue on the LTS way keep in mind you have to filter all of them because if your analysis don't use anything of the filter LTS it will not be used at all => no security applied. So make sure you add your filters everywhere because with LTS based security it's possible to bypass security if you left some…

It is on slideshare ... OBIEE Security: It’s a Jungle Out There Just didn't want to drown Manoj

Hi, Do you agree that your question isn't really related to OBIEE but a generic html/js question ? So Google that without mentioning OBIEE (as it's just a Web page). Just an additional question : your iPad users use a browser to connect to OBIEE or the native iOS app?

This remind me of a presentation two great guys did lately at Kscope16 ... So just a snapshot to visualize what Thomas and Christian are saying. OBIEE privileges = the settings in the Privileges page of the OBIEE front-end administration page Keep in mind application roles doesn't cost anything and can be linked together…

Simple answer? Not there out of the box ... Just because a time isn't an aggregate measure by default and the Y axis except to display an aggregate of numbers. You want to try to hack the XML for that? Well, you have the XSD available, look inside if there is a tag allowing you to set a special format on that axis ... (it…

Hi, The defined rules (Data Filters) are applied even if you don't select any column from the dimension with the rules on it (that's one of the problems with LTS filters, if you don't use the LTS => no filter => no security). If your BIAuthor inherit the rules of BiConsumer it's because your app roles are related. BIAuthor…

No, one prompt, one variable, one value (when you enter it by hand). (The exception is if you define a separator and then split the value of the variable to extract your values, for example 5.6|89|23.4 => 5.6 and 89 and 23.4 , but it's by far not user friendly at all ! )

Ok, so as you say you just don't want to filter your analysis the way it's designed to be and want to add a filter in your LTS instead. Well ... strange requirement As you say you have many fact tables why don't you add the filters by default to all of them? Then by setting the content level on your LTS you get what you…

Hi, As your vertical axis is supposed to be an aggregated value, what kind of aggregation do you have there? What is the original data type of your Y column?

Hi, Not really sure to know what you are asking... If your analysis is sales by week there is nothing to detect as your analysis is at the week level, so you know it because you built it like that and you add the good filter to be at the week level... What kind of filter do you want to do in the RPD?

What Christian suggest isn't going to store your target, so each time you open the dashboard you have to enter it. What you can do is to use writeback to store it back in your DB, to use an action link calling an UPDATE LSQL or to include in your dashboard via an iframe an input page (APEX or any other web-based input tool…

Hi, Well ... a simple table with 3 columns: Current value, Target value, % achieved / delta or whatever name cross your mind. You don't need a KPI at all for that (add some conditional formatting for red-yellow-green colors, trend icons etc. and you have the same as the KPI ...)