Well ... still no idea why your bitools/bin folder is so "empty" .... Did you try to search the migration-tool.sh in all the subfolders of your OBIEE install folder? There is maybe a copy around (the original one the config copy and deploy in the bitools/bin folder). PS: with 12c no need to run the RCU by hand, the config…

And you did all the steps? Because the migration-tool.sh is supposed to be there (as the doc says as well). Which version of 12c did you install? And you installed 12c inside the SampleApp 406 ? (coming with a 11.1.1.7.1 by default)

Hi, Did your 12c install went fine? Because your /user_projects/domains/bi/bitools/bin/ folder is a bit "empty" compared to a normal install ....

Actually an absolute path is easier for debugging and maintaining the catalog "from outside". Using relative paths would be easier at a first look if objects (analysis, prompts etc.) are inside the dashboard folder, but if outside when having to deal with ../ etc. is easily a nightmare ... And the relative path would make…

To extend what @Joel Acha posted (which is correct) it's not about a process it's just how the tool works. Object embedded into a dashboard are referenced by an absolute path and not a relative one based on the dashboard itself. So your analysis added to a dashboard will be referenced by it's position from the root of the…

Hi Dilek, dileraco wrote:I know that each attribute column should correspond to one dimension table. I disagree with this one ... Fact table must contains only measures, attributes must go into dimensions but I wouldn't really say that each column is supposed to be a dimension. You can also have a kind of generic dimension…

Hi, Well, of course they can co-exists as they don't share anything ... So they will just not be aware one of the other I don't think Oracle has recommendations on that as they don't interact the 2 products (so it's all about your server: if it has 4Gb RAM just forget but if it's a real server with enough resources based…

Hi, did you try by WLST ? I already saw cases where the EM gui wasn't working anymore but by command line using WLST worked without problems. You go to your FMW home, then run ./Oracle_BI1/common/bin/wlst.sh (really take this one because there are 1-2 others which aren't going to work). When it open enter:…

Another example: you have a fact table that only exist at the Company level. If you don't add the other columns to the "Offices company" level in the hierarchies but want to use them in an analysis with data from the fact table existing only at the company level you will get an error first. If then you set the content…

You can display as many as you want. The "default" display column when using the "hierarchy" object in a report only show one, but all the others are still there. And when you use in an analysis these other columns and then maybe mix aggregations levels etc. OBIEE knows that these columns are at that level, so doing a…

Are you saying in your fact tables you have attributes without aggregation rule on them? Well ... of course that can't work. A text isn't a measure and has nothing to do in a fact table. Look at degenerated dimensions, it's how to correctly model attributes coming from the physical table being the source for a fact table.

Hi, The idea isn't to have only one column per level but more to put all the columns in the right level. So for the "Offices Company" level what columns do you have at that level of the hierarchy? Company and Company Key. If you had a "Company long name", "Company address", "Company attribute" they would also all go there…

Are yours physical servers? vm? network disk? (DAS/NAS) Honestly disk doesn't cost a lot nowadays and so I guess you can easily give it a bit more (50-75) if you can, knowing it will not be used but at least it's available. Mainly if you start updating to new versions installing them next to each other it will increase…

And https://docs.oracle.com/middleware/1221/core/BIEIG/GUID-E6545BC6-D0BF-4521-B3E7-160ABBBB6CD3.htm#ASINS325 (which actually point also on the previous link)

Ok, so real PROD server. Did you have a look at https://docs.oracle.com/cd/E23104_01/sysreqs1221/sysrs.htm#BABEBFHJ ?

Hi, What is your target? The minimum to perform an install is quite low, but if you then want to patch etc. you need a lot more. So do you look for some papers minimum requirements coming from an Oracle document or you are looking for something else for a different kind of need?

Not answering your question but for the future try to gives few extra pieces... Like the version you use as there are so many around and works in different ways. How To Ask Questions The Smart Way PS: I see you have a obiee11g tag, but that's not so obvious to see, and 11g which one? 11.1.1.5, 11.1.1.6, 11.1.1.7, 11.1.1.9?…

Hi, Did you correctly set the content levels in your business model? Because the error you have means your didn't provide OBIEE enough info to know how to manage the conformed dimensions to mix together the values from your multiple fact tables.

Gianni Ceresa wrote:If that's your question of course you can deploy a RPD without log into the server where OBIEE is installed.

Why do you think I asked you if you had an OBIEE admin account? I could have told you that 3 weeks ago if you answered as it's there since the first 12.2.1.0.0 release more than 1 year ago...