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

Hi, It can depend on your cube .... Sometime you must add at least a filter for the dim your aren't using just because the cube has no data at the gen1 of that dimension. Sometime you just choose what you need and it's enough, no need of any reference to other dims. But it's all about how your cube looks like ...

3174977 wrote:[nQSError: 75027] Failed to open connection to SMTP Server (host 10.1.99.5; port 25). Do you have some other agents sending out emails? Do they work? The error message doesn't say anything about OBIEE users or non OBIEE users but just complain about not being able to connect to your SMTP ....

For infos on developing a custom style in 12c have a look at the doc here: http://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG9198

Ok, so as said on mobile 12c will works better than 11g as it now uses HTML5 charts instead of flash, but it will not be perfect and probably at some points will look badly ... So you can develop mobile apps using BI MAD or use the native iOS / Android app (for example…

Hi, If you create your own custom style you can use media queries, just don't forget a little detail: OBIEE isn't a small website with some simple code and a table in the middle of the page. The UI is quite "big", with many elements that you can't really control (generated by the system) and you can try to define your…

Hi, responsive design like a website adapting to the screen size / device used by the user changing the interface to be usable from a smartphone to a big screen? If it's what you mean ... not really ... A responsive design is supposed to cover the full page, and in OBIEE when you build a dashboard you only work on the…

Well, a calculated item with selection steps is not the best approach for that because of how selection steps works (and where it happen) ... Define "change the format" : what are you trying to do? PS: "Income" and "Gallons" are attributes of a dimension in your model? Aren't they supposed to be measures?

You add a new column to your criteria, you click on "edit formula", in the editor you enter your calculation referencing your columns (you find them in the list on the left or in the "column" button at the bottom).