Hi, Do you just want to filter the column based on multiple variables (multiple prompts) or do you want to do what your code was trying to do? (it's something else, a bit more precise than just what you say) "is not working" = ? What does it mean? No data? Too many data? Something else?

Hi, Obviously you have a syntax error as your CASE WHEN doesn't really mean anything ... CASE WHEN <condition> THEN <value> ELSE <value> END So what do you expect from your "table2."column" LIKE '%~ABC' as <value> after the THEN ? The <condition> can be as complex as you want using multiple columns like: "table1"."column1"…

Try at least to respect the syntax a bit .... '<a href="' || "Table name"."Column name" || '" target="_blank">this is is a URL</a>' EDIT: Christian, same reaction in the same time

Hi, First the "stupid" question ... is your Essbase process running, right?

Hi, This as already been answered at least once (this exact same need) on here ... First: why don't you use a column format instead of writing HTML in the formula? When you say "This doesn't work" what do you mean? What happen? The link doesn't work or it just doesn't open in a new window? Why don't you have anything…

It didn't change and you can have multiple DB schemas in the same data source (as long as all the schemas are from the same server / instance). Nothing new there ...

Ok, the simple way is: set open permissions on all the folders from the top shared one till the one with your analysis and on your analysis as well, in OBIEE privileges make sure your app role can access the catalog.

You say you saved few reports in a shared folder, how do you expect your users to open them? Will they open a dashboard containing the reports or do they have to go in the catalog and navigate to the folder containing the reports? Before to start setting random permissions it's better if you start by making sure you…

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?