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 ...)

The question is more why it was wrong in the DB? If somebody put its hands on the table changing the type of the column to collect more content .... simply avoid that! (I love to talk to myself ...) Gianni Ceresa wrote:Actually few SampleApp I checked all use that column as a VARCHAR 1024 (matching the size I found in the…

Actually few SampleApp I checked all use that column as a VARCHAR 1024 (matching the size I found in the DB). How come yours is 4000? Where does your S_NQ_ACCT table come from?

I don't have a running 11.1.1.9 (yours seems to be a 11.1.1.9) but in a 12.2.1.1 the QUERY_TEXT column of the usage tracking table is a lot smaller than 4000 (actually it's 1024 bytes). OBIEE varchar are limited at 4000 if I don't remember wrong, so you maybe have an error with encoding? As you use a system in Spanish (I…

Hi, Is it really OBIEE giving you the error? Because "ORA-01401" is a database error, and I found it quite strange that OBIEE use a ORA code for it's own errors. (Seeing an error in OBIEE doesn't mean the error is generated by OBIEE)

Hi, You missed a key element .... What version of OBIEE are you using? 12c deploy the RPD by script, so it will probably take you 45 seconds to automate that .... For 11g there are scripts around using WLST to deploy a new RPD. But it's all about your version ....

Actually there is a way to have a shared connection for OBIEE, it's all about an XML file you point to from SmartView. Some details: https://docs.oracle.com/cd/E38438_01/epm.111223/sv_user/frameset.htm?ch03s07.html @User13510650-Oracle : where does the shared connections info comes from? Did you set the XML file? If not…