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

Good news. Can you maybe close the thread so it can also help others in the same case and keep the place "clean"? Right now it is still This question is Not Answered.

If you got what you were looking for can you maybe close the thread? For now it's still This question is Not Answered.

Hi, A simple CASE WHEN your_value < 10 THEN '0' END || your_value You will need to manage the CAST to avoid errors (so number for the WHEN check and char/varchar for the concatenation.

If as a normal user you try to access saw.dll?IssueRawSQL directly in your browser does it works? Maybe you also need to give access to the admin page to allow the user to see that page....

Time to get in touch with the SMTP admin to see if they aren't a bit too strict with their config or why their server refuse connections. Not really something OBIEE can help with ...

I also have the same in agents with only email addresses. The value of Recipients in the Overview is not supposed to list the users / emails receiving the result but the kind of recipients. If you have OBIEE users it will be "specific recipients", if you choose to get recipients from a column of your condition it will…

Hi, listRepVars.js in SampleApp doesn't really use a webservice .... It contains this: xhttp.open("POST", "saw.dll?IssueRawSQL", false); This is the Issue SQL page in the Administration. So the permissions required is this one:

These links are about OBIEE 10g .... In 11g you have a button to add emails addresses directly.

+1 for Simon on that The code (both XML and LSQL) of analysis changed between 10g and 11g, OBIEE generates queries in 11g with some extra functions if needed and so copying LSQL between version is the best way to end up with a nice 11g environment but not really clean analysis. You can run the Upgrade Assistant as many…

Hi, Simply fix the size of your CHAR in the CAST function: CAST(...AS CHAR(4)) By doing that you don't have the space anymore between 2015 and 03. Tested with both your formulas, same result:

If Essbase for you is just the source and you aren't in charge of building the cube then you have no real option ... Try a report and if you have no data start adding filters on dimensions not in the criteria tab, the maximum you can do is ask to the owner of the cube if they can change things (but there can be many…

Well, it's not really a feature, it's called design ... Design and build your cube correctly and it's fine. If on the other side you have no or little idea of what Essbase is and how it works ... no other option than learn ... PS: Christian was quicker...