Hi, The BI consumer application role is supposed to be for users opening/viewing (but not editing or creating) reports. But the role by itself is not enough ... Is your security setup in a way to allow this app role to open reports where you saved them? What is the current security setup you have? (it seems you kept the…

Hi, Do you look for a one-shot or more something you can regularly run to keep in sync over time? Because I guess there isn't a simple utility doing that ... so it's all about how much is it worth to develop a way to do it ...

XSD = XML Schema Definition, the "grammar rules" of your XML If you try to change the XML of an analysis with something not matching the rules defined by the XSD OBIEE will refuse to save it and you get an error. If it's just about borders honestly you can manage that with borders around the views or set a border around a…

c0ffbb0d-a1cb-4779-b212-cf1631f2be04 wrote:Where in the database are all the timestamp for each step of OBIEE- BI Publisher. The job Processor and the Report Processor I guess Christian's point is more: what are you talking about? What does "timestamp for each step of OBIEE - BI Publiher" means in your mind?

Hi, Is "Dim Four"."Date DEF" physical column (the one mapped in the BMM) set as nullable? If it is by default OBIEE will add the NULL as the column is defined as nullable...

To stay on topic I join @Christian Berg : no, don't guess you can add a picture in the content of the mail (also because it looks like plain text and not even HTML ...)

Did I miss something? I suppose it was a "Thx Christian"

Hi, Do you have a measure for each single day? I don't guess so ... Why don't you use a pivot view and use your calendar dimension (if you don't have your date column) to have the date (month / day) and day name there on top ?

2844292 wrote:Just mention what all i need to follow. Hi, If you mean that you are looking for which parameter to change and what setting to do stop right now as this is probably the worst thing to do when you have "generic" not better identified performance problems .... First (second and third) activity is to find out…

Did you have a look at the XSD? You can't change anything in the XML OBIEE generate or it will be invalid. For custom legends there is the custom view, or rename the columns according to the new name you wants.

BINGO ! That's what many posted since the beginning: are you sure your LTS has all the required joins to be able to return data for your analysis? The error page sounds like a "no". So look at the error and identify what joins / granularity you are missing and solve it (by changing your RPD or removing things from the…

If you disable all the others LTS does the analysis still work or you have an error?

No there isn't another way to define "priority". First is the one able to answer the query, then the one with lower priority group and then the order (the one on top is used before the one below). So I guess, as others said already, you must double check again that your expect LTS can answer the query ...

Hi Sandeep, Do you agree that you actually don't really provide anything to help us helping you? You are the one with the model in front of you, with the data in front of you and with the "wrong sum" in front of you. So start by defining "wrong": is it really wrong (like 1 + 2 = 5) or it's just not what you expect for any…

Sorry, are you really saying that Visual Analyzer and analysis & dashboard do the same thing? c13f9574-c5c5-410d-8277-d58d1eb79e96 wrote:because I see that do the same! Are you really looking at OBIEE 12c? Because they look and act different enough to not really see them as "do the same" ... If you expect one to make…

Hi, Not sure to get what your question is ... Are you asking if Visual Analyzer in OBIEE 12c is the same thing as Answers and Dashboard (so the "old" way of doing things that was there already in 11g and earlier) ? No, they aren't the same, they work in a different way and they target different needs. Also important to…

As said earlier you can also do the same on a linux instance (as far as I remember linux instances are cheaper than Windows). AWS or not the install process is exactly the same, nothing change, so you can follow the official documentation or any "real" install tutorial you find online. The AWS difference is only that your…

Hi, Honestly I don't really think you can setup and run OBIEE + DB on AWS using the free tier. The free part give you access to a t2.micro instance (or more than one of that kind). The t2.micro is 1 vCPU and 1Gb or memory. After running the OS (linux ideally) you will still have 800-900 Mb or memory, but you have no…

Hi, Why don't you just do a search/replace in the catalog to replace all the old references with the new column name? Because the alias in the Admin tool is more for name changes (typos etc.) but doesn't really contains the parent of the column, so it will not be able to keep the old "parent" name.

Just add a new column to your criteria and edit the formula to be 100 - "Null percent (in %)". In your pie chart properties you use the "Measure Labels" as slices and set "Attribute" as pies. (12c or 11g is the same for this ...)