Hi, TIMESTAMPADD(SQL_TSI_YEAR, -1, CURRENT_DATE)

Hi, as OBIEE is a web app just fix it by a CSS style: text-transform: uppercase;

Hi, why to not manage it in the query populating the variable? If there is no value then you return all the values?

Hi, your problem is almost impossible to solve in a user friendly way .... You said you have 10 indicators (10 different prompts fields) and for each one you want to chose AND / OR. But ... What about ( and ) ? indicator1 AND ( indicator2 OR indicator3 ) is different than ( indicator 1 AND indicator2 ) OR indicator3 Make…

Just a detail .... <MONTH COL> isn't the month column in your subject area ! The second parameter of the AGO function is the level name of the time dimension you want to you for your AGO (by changing this value you have day ago, month ago, year ago etc.)

Hi, What have you tried exactly? Did you analyse the reason of the NULL values? If you just make a simple analysis by filtering on a single month can you manage to get a measure and the same using the AGO function? Is is this one return NULL? What does your formula looks like? What does the physical query looks like? If…

Hi, So you want to move all the values of the "Rows" area of the pivot to the right of the pivot itself? (it's not just about text being written right-left, right?) If you want to do that you will not find an easy solution, it would require HTML reworking on the pivot, moving the <td> tags around (from the beginning to the…

Hi, Current_month you have it by the filter on the month column (based on the prompt where you select the month). Add a new column where you use the AGO function on your measure to get the previous month figures. Add a 3rd column where you calculate the variance by using the previous 2 columns. For the AGO function to work…

Have a look at this : Agents not working when :USER :PASSWORD used in connection pool Same situation, same issue ...

Hi, What are the values of username and password in your connection pool? It's maybe :USER and :PASSWORD ?

What are you going to put in "Measures" area of your pivot? There you are supposed to have at least 2 columns (and it's what is supposed to be your measures). If it's a column, a formula using 10 other columns or anything else doesn't make any difference ... If for each heading value (Revenue and Gross Profit) you are…

Hi, Are you sure your column with "REVENUE" and "GROSS PROFIT" is just a heading? Isn't it the name of the measures you will display in the pivot ? Because you have the same set of products repeated for both Revenue and Gross Profit, so this means you have at least 2 measures. In that case as long as your 2 measures are…

Hi, OBIEE will not complain at all if you use a date instead of a number. Everything will work without problems, no issues on that side.

Hi Dan, Did you try to switch your columns from "suppress" to "repeat" ? Doing this on all the columns where you want to remove the merging will repeat the value on each rows both in the dashboard and in the exported Excel.

One of the main changes between 10g and 11g is that security has been moved from the RPD to Weblogic. So the management of application roles and their members is now done in Enterprise Manager. In the RPD you see a list of application roles and users to allow you to define security or other limitations based on them but…

Hi, Which version of OBIEE are you using? You mention a document about OBIEE 10g but tagged your post as 11g. In 11g things works in a different way: you add users/groups to approles in Enterprise Manager. Look at the doc for the correct version of OBIEE and you have all the details (or also googling you will find tons of…

I would say that what the link is doesn't matter much. The thing is that if DV doesn't give you any option to set the target (html links generally use "_blank" to open a new window/tab or "_self" to say it should navigate to the link in the current window/tab), there is maybe not much you can do... You could try to enter…

Connecting all the dots... What you are asking is how to have an image in a DV workbook with a link, and when you click that image inside the DV workbook the link should open in the current window/tab and not in a new page. Did I understand your need correctly?

Do you really have dashboards? Or you mean DV workbooks? Is your homepage/landing page a dashboard (a real dashboard) or just another DV workbook? Is that homepage/landing page in DV or in 'classic'?

Did you search what sources are supported by your Essbase? Because that's the first step. If you find that your new source is supported, you can then start looking at how to make that connection.