When I want to used option in rpd Create Logical Dimension -> Dimension with Level-Based Hierarchy a get this error: AdminTool is unable to create the structure for dimension. But I was able to finally make a hierarchy manually - screenshots above. However, when I start the analysis (as described above), it appears to me…

Hi Andrew, I've tried both manually create the same dimension and the entire hierarchy, you use the cast () and all the time or you can not create a Logical Dimension or the creature it manually it throws this error. I have something like that: Fact(1) Fact(2) OPERATION SEQ NUM: Hierarchy:

When I tried create Logical Dimension manual (without using: Create Logical Dimension/Dimension with Level-Based Hierarchy in rpd) -it's ok - I create logical dimension, but I got an error when creating analysis. When I using one column from dimension, two column from different fact it's ok. But When I add this column…

Hi, Thanks for response. I tried cast VARCHAT to DOUBLE or DOUBLE to VARCHAR but I still have the same error. My example cast to double: I add that dimension with one source (whichever table) working fine.

Try: OBIEE 11g Image Path / Adding image in OBIEE 11g or 10g | OBIEE Tips & Tricks C:\OBIEE11g\Oracle_BI1\bifoundation\web\app\res\s_blafp\images C:\OBIEE11g\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\images

Hi, What version Mozilla Firefox are you using? I'm think that you can try Mozilla Firefox 38.0.6 with the newest Adobe Flash Player. I use this combination and everything is working properly, for example: OBIA with OBIEE Oracle Business Intelligence 11.1.1.7.131017 or ASCP with Oracle Business Intelligence 11.1.1.6.5. Try…

Hi, What error? Add screen or past error text.

Hi, I understand that you use Presentation Variable in prompt? If yes, you can use narrative view. Write text and put in it something like that: @{variable_name}. For example: "The Report above is for @{FY} results for @{Program Name} Program in @{Region}"

Hi, Try to use Conversion Funstions -> IFNULL. IFNULL(column measure, value) For your measure: IFNULL("Resolved Cases", 0)

Maybe try this: http://www.sandeepvenu.com/2013/11/get-user-session-details-in-obiee-11g.html

Hi, I think that you should use: VALUEOF(NQ_SESSION.session_variable) And maybe in SQL results you should create something like that: Select <presentation table>.<presentation column> from <subject area> where <presentation table>.<presentationation column> = valueof(NQ_SESSION.<session variable>)

Hi, Try use formule like this: max(Type) If the Type column has a value of "S" and "O" they will always appear larger ones or "S" .

Hi, Look here: about Tmp

Hi, About print/export strategy tree. I think that you should create dashboard with scorecard objects (i.e. strategy tree) and then you can you can Print (PDF/HTML) or Export to excel this object. I know that with scorecard objects Export to Excel working fine, but print to pdf may not work.

Hi, You past this code in wrong place. When you click PPM on for exmaple Actual Hours Column and choose Filter, when next you must click Convert this filter to sql and click OK. And it opens a new windows: Advanced SQL filter and there past code. And end view: If I helped, then give the correct answer.

Hi, If you don't show project with actual hours and plan hours equal to zero, you must create something likt that in filter: Principle of operation: NOT ( A and B) == (NOT A) or (NOT B) Or add this two filters with sql: (Actual Hours <> 0 OR Plan Hours <> 0)

Hi, It seems that you used there Row Level Grand Total but SubTotal. Do it this way: Delete records from the podumowania. Then start again the analysis, go to the tab: Results. Once you will see the table PPM for the first column: Balance Sheet Category. I select: Balance Sheet Category -> Show row level Grand Total ->…

Hi, I work on OBIEE 11.1.1.7.131017 and it's working fine both on table and graph. And on the Bar Graph: Or in Line Graph: Maybe, try again to perform this operation.

Hi, Here you have some tutorial: http://www.tutorialspoint.com/obiee/index.htm I think you'll find most of the basics. To learn how to use OBIEE start to use it and have extensive documentation in which you have everything. http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/documentation/bi-ee-087853.html

Hi, I do not think that as a 11g was built function mode. It is possible that the version 12c are added statistical functions. However, perhaps you can work around this by a simple calculation on the analysis. If you have, say, two columns: suppliers and a number of repeating them. Suppliers || Measure Column A || 1 B || 2…