Hi, This question come back every 3 days and the answer is always the same .... Before to "improve performance" you must understand (bad) performance of your current report. What happen when you open it, where time is spent etc. Look at the first reply to this thread from @rmoff : How to improve the performance of…

Have a look at this (same as your case but with different names ...) : Column B (your "Col2") is the hardcoded value, I used 'table 1' and 'table 2' but you can use 0 and 1 as numbers. Column A is your "Col1", each logical table source point to its own column. For each logical table source you set a rule for "Fragmentation…

Well, Essbase store data as ... in a cube You can't really try to find same things as tables, views (which actually doesn't story any data) etc. A cube is built using dimensions, each dimension has one or many levels (you can also refer to them as generations: level 0 is the leaf, generation 1 is the root of the dimension…

For your logical table you add 2 logical table source, one for each of the physical table. In the column definition you hardcode the value of the 2nd column for both the LTS (so you have your source) and then you define a fragmentation rule in your 2 LTS based on the value of the hardcoded column.

Well, I understand (and agree in part) with your Essbase developers about entering values. But that's why you have calculation scripts (if BSO, if yours is ASO it's supposed to be dynamic, but I guess yours is BSO) to aggregate and propagate data to the upper levels and so you can get data with some high levels filters and…

Do you always need to set all the filters? Don't you maybe just need to set some high level one and then having the column in the analysis is enough to explore your data? Other option is to look on the cube side if it can't be designed a bit better for analytical needs.

Hi, CASE WHEN .... THEN .... WHEN .... THEN .... WHEN .... THEN .... ELSE .... END

Do you have the permissions to use Publisher? Because there is still a link there in the homepage. Plan B: go in the "New" menu and you find all the Publisher objects.

Hi, Did you try by setting the SKIN system session variable? Look at table 19-1 here: https://docs.oracle.com/cd/E23943_01/bi.1111/e10540/variables.htm#BIEMG3104 Or also google / search the forum for the SKIN system session variable...

Hi, Usage tracking is the most user friendly and simple way to do that. So just enable it and it's done, it will start collecting data and so you can then do analysis on it.

The CASE statement is in the column formula or your analysis (or in the BMM if you want to maintain a single column there as well). And in this CASE statement you use a variable to identify the environment. I think there is a default system variable defining the BI server hostname, so you can use that one, or you can set a…

Hi, Use a CASE WHEN based on the server name (your DEV, TEST, PROD have different hostnames).

Hi, Welcome to the forum .... Where does OBIEE fit into your question? You are actually posting in the space but it smells like a "generic" SQL question ... There are many other spaces for DB / SQL questions in case.

Can't be done in the XML as it's what makes a view selector a view selector, so the XML can't help you...

Do what Thomas posted. Don't do at all a filesystem copy of what you guess is the RPD from the server to your desktop and back. 12c changed many things around how the RPD is managed, so you must get a local copy using the provided tools (command line script to download /upload the RPD).

Hi, How is this thread different than what you posted in When the OBIEE report is exported to Excel 2007 date columns are saved as text instead of date ? Don't double post and don't start multiple threads for the same things as the result is in general less answers and more unclosed threads in the forum...

Hi, In 12c things are changing a bit but right new the answers are still "easy": 1) Only one single repository (multi instance is one of the coming feature of 12c but for now it's still only one). Because of this new multi instance architecture things are a bit different on the disk, but there is still only one RPD in your…

The miracles of "Search" obiee baseline validation tool usage And you don't need to run BVT from the server, it perfectly works running it on your local machine.

In this example when I click on the bar chart it send the year to the table on the left, so it works from bar chart to table (I just did this sample on 12c right now). So it works... You don't define a master view, you define the interaction on the column to send a master-detail event, and in the views you just define…

In addition to what Christian said : there aren't user groups by domain (you post "Oracle BI Foundation 11"), some have a SIG but that's it ...