What kind of model do you have? If the table give you a total for your date it means it's a measure and so it can be right but it can also (often) be wrong ...

Did you try deleting all the temporary files of IE? (cache and everything)

Based on my observations with Windows based setups the main issues can be this: user8026192 wrote:Point being it is easier for someone to jump if the software is Windows based. That's what often gives you issues ! OBIEE being a server tool require a real Windows sysadmin and not just any random guy with a Windows laptop…

@FTisiot pointed you in the right direction, it's the apache timeout setting. OHS act as a proxy: you (the user) ask OHS, OHS asks OBIEE. OBIEE reply to OHS, OHS take it and use it to reply to you (the user) (https://en.wikipedia.org/wiki/Proxy_server ) So you have 2 timeouts to manage: the OBIEE one which was fine as you…

Hi, Not a simple thing ... Results in 12c are loaded as ajax calls, so by definition they are asynchronous : you see them go, you don't know when they are back ... I'm not sure if OBIEE itself has an idea (or a way) to tell when the page is fully loaded as this means you know how many ajax request the page sent and you…

Being you I would then go back and start from scratch, an empty VM. If you don't want to focus on the DB you keep it in the second vm and so your OBIEE vm is just for OBIEE, like a real setup would be (you will never install DB and OBIEE on the same server in a prod environment). So you don't really need to ask yourself if…

I would say you better ignore if it's there or not and install the one coming with OBIEE 12c (the right version) following the OBIEE install doc, so you don't have to first find it and second maybe fight with it because it's installed and setup for something else. I assume you are using that VM to not have to install the…

Is there something different between the 2 database objects (and connection pools) in the 2 versions? A different database type? A different connection pool? A different way to identify the database in the connection pool?

FTisiot wrote:if after executingjava - version you get a java version that is compatible with OBIEE installation you should be fine if not ... installing the right java on the Oracle DB Developer VM (must be a OEL6 or 7) is done in 5 minutes (1 to find the right file, 3.5 to download and 0.5 for the unique command…

Just a detail (not directly related to your current error but to the next ones you will probably have): what OS is yours? It smells like Windows 7. I guess you checked the certification matrix and choose a OS based on that, just to be sure to have all the chances to succeed and not have errors because of an unsupported OS,…

In the physical layer you can add an opaque view instead of a database object. But it's generally a last option thing, as you are just going to hide logic there, so model things correctly or try to push the code to the database directly if possible. For the "how" it's just a right-click to add a new object. If you provide…

3371002 wrote:Sorry all, I should have mentioned that SELECT YEAR(CURRENT_DATE) FROM "your subject area" worked well for me. So you maybe have a button around to close the thread (or mark as correct or something like that)? For now it's still This question is Not Answered.

But you don't have item_id in the parent report, or if you have it it's excluded (which is a bad practice). Your model is a bit strange (not complete or wrong): as there is a link connecting these datasets, that link can be modelled in the RPD so you can really use the OBIEE functionality of navigation and drill to analyze…

Hi, 3018071 wrote:All i need is, i need to pass all the item numbers from parent report to child report. This is actually the wrong question and wrong approach... In your summarized table the item numbers doesn't exist, it's an aggregated view, so you do not pass the item numbers to the child report but you pass the…

Hi, Enjoy that dashboard, sounds like fun ... Because of the lack of question marks I assume you aren't asking people on here to make it for you, right? https://www.youtube.com/watch?v=5CgBmj7Jz6Y&t=19s

Did you check where the space come from? If you inspect the page with your browser's Developer tools extension (the name maybe is different but they all have it now), what do you find where you have the spaces? If you have elements there, even if empty (like a <div> or things like that) of course they "take some place" in…

Hi, is it me or your whole thread focus on the wrong bit of your situation? You posted lot of details about your columns etc. but still say your variable return 0 and so the column isn't "None"."None" but the value of the variable ... 0. So where does your variable come from? How did you setup the prompt defining the…

I'm not going to say it doesn't work as there is for sure a way to make it work using EVALUATE, but if going down that way why not create a Excel file containing a macro which generate the current fiscal year and then generate a CSV file which is read by a ODI (or any other ETL tool) and loaded in a database. Then the…

Can your client resolve "dev" correctly? And why don't you just use the first one? Entering the host and port? Are you trying to connect to a cluster with multiple hosts?

You have selected "Connect Directly To The Active Scheduler (Use 'localhost' for local machine)" but your hostname/IP and port are empty. It works better if you enter something there ... PS: you can write into those drop down lists, the lists will be useful to reconnect to other instances without rewriting