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...

Sree!!! wrote:Give me some solution. Some solutions? Don't lock your pc, install a different browser, turn 5 times around your desk before to unlock it .... </sarcasm> How To Ask Questions The Smart Way Do you really believe you provided the minimum amount of required information to give you a real answer?

And something called "versioning" ? You are supposed to keep a track of that value. If you don't, seems to be your case, just stop looking right now as it's logically impossible to do what you ask and OBIEE can't do anything about it. If you don't have that "step" value versioned how do you want to have a logic knowing if…

If you really want to change that 9999 try to change it in the RPD. Check the features of your database definition in the Physical layer. There is an entry named MAX_ENTRIES_PER_IN_LIST, if you change the limit there you must be able to get more than 9999. (But again, I would highly suggest to make that with joins instead)

Hi, Did you try to put 11k values in a IN in your DB physical query? Don't you get the same error? More in general .... do you really have to have a query with 11k values in a IN ? That's what joins are used for in SQL ...

Hi, Your answer depends on your data... You must not send the email when your "step" is = 5, you must send the email when "step" = 5 AND previous "step" = 4. So your data and model must link step with time and you must be able to query the current and previous step (based on time and not on step values). That's how you can…

Are you surprised it doesn't work if you want to do things in a random wrong way? There is something called the official OBIEE documentation and it cover in details how to create a custom skin / style. Search into the "Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition" and…

Instead of exiting the dashboard and enter again did you try the "Clear my customization"? Because that's what it's supposed to do ... reset all your changes you did while using the dashboard page. PS: not really sure which one is the question actually in your post....

Yes, that one will accept the setting (and you will not kill your presentation service )