Ideally, you'd have a time dimension in which you fiscal year attributes are defined and then quite simply, all you'd need is to build your query/report based on a filter of time dimension records where the fiscal year is 2016.

In most Organisations, automatic access to the SMTP Server is revoked. You’ll need to find out from your IT guys whether this is a case and then they’ll need to give your OBIEE server access to the SMTP server.

Something along these lines: http://www.rittmanmead.com/2011/11/obiee11g-scripting-–-generate-xudml-and-change-the-password-of-the-connection-pools/

The Admin tool uses its own tnsnames file. Create or copy your tnsnames.ora file to /config/fmwconfig/bienv/core Sent from my iPhone

The Admin tool uses its own tnsnames file. Create or copy your tnsnames.ora file to <DOMAIN_HOME>/config/fmwconfig/bienv/core

Your CASE statement "return values" should be of a consistent data type. In your case, you're returning a VARCHAR, NUMBER & a DOUBLE. I suggest that you convert your "return values" to a consistent data type, in your case, convert quantity by doing this: CAST(Planner WorkBench"."DW_SUPPLY_DEMAND"."QUANTITY" AS CHAR) and…

Hi @3239449 if I understand you correctly, you have a dashboard prompt which users can use to enter Month end for their Balance Sheet. FIrst thing to do would be to populate a Presentation Variable in your Dashboard Prompt. Pass this variable to your filter of your balance sheet report. IF you have a time hierarchy set up,…

Hi @raykdogs, what you'll need is to create a UNION report. You can either do this in the report itself, in the repository as an opaque view or you can create a UNION view on your database and import this into your Rpd. As you mentioned, the Year is what is common to all tables. All your tables have the same column set so…

What Christian and Pedro F have asked you to check is whether or not the SQL generated from your "XML" is the same for your Admin user and when user runs the same "XML". If it is the same, have you run the SQL directly on database as Admin and user? Have you checked if the connection pool runs as a particular DB user? Is…

Yep, you were faster on the trigger @Christian Berg!

It means that you have no other corresponding subject areas that are compatible with the current subject area. Are all your subject areas based on the same BMM model in Rpd? For you to be able to add multiple subject areas to the same report, they need to all be based on the same BMM model. Sent from my iPad

Thanks for clearing that up @Gianni Ceresa.

Silly question but have you tried out other browsers? Do you still get the same folder display in other browsers? Additionally, are you using a compatible browser version? - http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html Sent from my iPad

Your best bet is to raise an SR and find out if there is an 11.1.1.5 patch for this bug. If there isn't, then your only other option is to upgrade or a very crude alternative is to set some job which systematically deletes these core dumps.

Hi @783226 I presume that you meant version 11.1.1.5. If so, there is a bug listed in MOS - Bug 14643648 : CATALOGCRAWLER CRASH IN ODBC

The only way you'd be able to achieve this is to create a separate pivot table with the dates as hidden column headers (no rows defined) and the cells would be a copy of your measure column multiplied by 40 You'll then need to align both pivot tables in your compound layout to give that illusion that it is a single pivot…

It sounds like you know the ideal and probably the only solution is to set up your date dimension with hierarchical levels and you get the time series functionality for "free". Anything else will be difficult to implement and will give you lots of issues down the line.

It isn't: http://docs.oracle.com/cd/E10415_01/doc/bi.1013/e10417.pdf The compatibility matrix for OBIEE can be found here

Easiest way to achieve this would be to "trick" OBIEE into thinking columns are different. Simply add a space at the end of your column formula on your report on dashboard page 3. For dashboard prompts to work with is prompted filtering, the column formulas in the dashboard prompt definition and the is prompted filter…