Hi, It's gone ... There isn't a public Sample App anymore, it's quite some time already The 2 options you have are: a) run your own Sample App: OBIEE Samples b) get a trial account on Oracle Cloud and start an OAC instance and for 30 days you will have an online environment you can start when needed There isn't any sign so…

My bad ... I was thinking at a column formula, not a calculated item. A calculated item just can't accept CASE WHEN, it only accept simple calculation between items. That's because your "pickup" column isn't a measure or anything like that, it's just an extra item added into the values of the 'snapshot date' column.

I smelled a pivot and an intra-dimension calculation How are the last 2 dates defined? Do they come from a prompt or from a variable or something? You could use FILTER instead of $3 and $4, so you are sure about what happen The thing with CASE WHEN is that the condition to say if the calculation must be done or not can't…

Joining Christian comment I suspect something a bit "weird", so if you post more details (I imagine a screenshot is asking too much) it will be easier to point you in the right direction more precisely.

Hi, A formula is a formula and execute what you wrote, so if you want to apply it only to some rows you need to write the conditions in the formula itself to say when it must be used or not. CASE WHEN is the most used approach for that.

3004672 wrote:We have migrated our OBIEE Catalog & RPD info from one server box to another server box. How did you migrate and what exact version of OBIEE are you using?

Hi, I'm not sure to "see" what you try to get as final result ... (It's Monday) You would like in an existing listing of employees coming from your "Employees" subject area display attributes like "Job" and "Organization" and that's fine as you have those attributes in the "Employees" SA. But now you would also like to…

Hi, Sorry but ... what do you expect from the forum and/or ODC? You aren't really asking anything, and based on your statement I can just say: go ahead, do it !

I definitely know what OBIEE is, what Publisher is, and what and how and where Publisher is in OBIEE. Your wording is confusing as there isn't a thing called "OBIEE Publisher", it's either OBIEE or Publisher and they are quite different (even more when about security if you aren't using the Fusion Middleware secuity in…

Sorry but is that OBIEE or Publisher? You talk about OBIEE things but call it OBIEE Publisher (they are 2 different products in the end), so it's slightly confusing ... And no need to mention that support for your version of OBIEE was over 4 years ago, you may want to consider to upgrade one day ... Is your "user_n1" a new…

If I'm not wrong there is a plugin for IIS which make IIS act as a proxy in front of weblogic. A bit like OHS (Oracle HTTP Server) which is just Apache acting as proxy. I never set it up in IIS, but there was/is definitely a little plugin making this "proxy-like" setup. So "UI hosted on Windows" sounds like a pretty poor…

Hi, It somehow complain about incompatible types. Does the analysis ("report" = Publisher, "analysis" = the one you are opening ) contain a UNION? Is that something you copy/paste edited, migrated or moved around for a while? Does the same happen if you create a new (from scratch) analysis with the same logic?

Mukeshs wrote:What metrics do we need to set in order to measure OBIEE performance ? So it seems you are trying to do something as a wrong answer to the wrong question. There isn't a thing called "OBIEE performance". You can measure page rendering time, Kb/s delivered over the network, page views per day and another amount…

Hi, You are using a 2015 patch with a browser of 2018, browser which has quite many changes in the javascript management at every release to make it faster etc. So if Chrome is the only one not working you are just facing an incompatibility. You would need to at least apply the 171017 bundle patch hoping it will fix it as…

To recap the various pieces above, for your need the most effective way (IMHO) is runcat.sh by command line. runcat.sh -cmd rename -help runcat.sh -cmd replace -help These 2 gives you the help of the 2 commands with examples and all the options. I would run them in offline mode as it will also cover the /users folders. To…

Oh, I forgot to write it but sounded obvious in my mind You still have to rename the folder yourself by hand (in cat manager, not on the filesystem), just a right click rename or something like that. The "search & replace" will only change all the references so that the various pieces will link to the new folder name.…

As Christian said ... OBIEE has never been backward compatible. It isn't part of the development process to have various environments using different versions in parallel, things are supposed to be aligned.

Have a look in MOS there is (at least) a note about this with the details on what and how to update it.

@Pedro F : didn't you have some fun not long ago with search&replace and paths?

And what about "Marketing&Advertisement" ? Never underestimate double encoding because web interface and XML (not saying it's the case, but everything is possible ....)