Hi, How do you share your prompt value with your report heading? Try to use a presentation variable, set that directly on your prompt and then make a custom heading for your report using a narrative view, call your presentation variable usgin this sintax '@{var}{defaults}' Let me know if it works fine Felipe Idalgo

Hi, Which OBIEE version are u using? Post a screenshot here Felipe Idalgo

Hi, Did you add your dimension column on this analysis too or just fact columns? Try that: Just drag and drop for your criteria tab 1 - Dimension Column (to summarize your measures) / 2 - FACT1 Column (ensure that is linked to dimension called early) / 3 - FACT2 Column (ensure that is linked to dimension called early) It…

Hi, Migration from OBIEE 11g to OBIEE 12c don't affect default skin/style Change default skin/style It's not a good idea, You can have many problems after that. It's recommended that you create your custom style Please review that http://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG9186 Answering…

Hi, Open your RPD online, go to Menu > Identity > Double-Click on Administration Role and then go to privilegies and set this role (or user if you want) to "allow directly database requests". Try once again Hope this help Felipe Idalgo

Hi, If you install OBIEE 11g and Essbase together you can use weblogic user to connect to Essbase server Can you connect to OBIEE analytics (http://server:9704/analytics) ? Which full address are u using to access Essbase Admin Services? Note that 9704 is the port used to acess EAS, but if you wanna to acess Essbase data…

Hi, Then you have just one analysis with above logic and you wanna use inline prompts? is that ok? Felipe Idalgo

Hi, I can't undestand you very well Are u using a sQL view on source (RPD - Physical Layer) instead of a table and you wanna filter that by date? Why didn't you apply that directly on your analysis? a view will be solved by DB equally unless you use a materialized view Felipe Idalgo

Hi, I don't know if there is other easily way, but I would try that: Supose you has one PPT (prompt) and one Analysis (Report) linked between them PPT (with month range) ---> Analysis (must receive PV calculated) 1 - Create a auxiliary analysis for receive PV and then calculate your months according you want On this…

Hi, Did your environment work early? Execute status.sh and post out here Felipe Idalgo

Hi, Custom skin/style aren't working properly in OBIEE 12c yet I made this workaround in a custumer here in Brazil, this approach was validated by Oracle USA 1 - Go to your analytics.ear folder "[ORACLE_HOME]/bi/bifoundation/jee/"; 2 - Make a backup from analytics.ear, if you have any problem on that, you will use this…

+1 @cesar.advincula.o note that detailed analysis must have a a filter used in navigation this type of filter will depend if the data of the analysis are correlated or not Post a picture of your model (physical, logical...) Felipe Idalgo

Hi, Are you trying to import metadata on a offline or online connection? If you're trying to import that in online mode, you have sure your OBIEE server can see your DB server. Try to add your TNSNAMES.ora at {DOMAIN_HOME}/config/fmwconfig/bienv/core e.g.…

Hi, You can derive your logical columns from physical columns or from other logical columns already mapped. I can not see the image right, but it seems to me that the first image is a mapping logical column to physical and the second image you have a mapping of logical column from a logic column. OBI will always seek its…

Hi plyskovich Could you implement a custom style this way? I did a migration last week from OBI 11.1.1.7 to 12.2.1 and when I try to implement my custom style it does not work fine. OBIEE cannot find my custom style (I tried both 2 aproaches). I can do that by downloading analytics.ear to my desktop, then I use 7-zip to…

Hi, You must have sure your user was assigned to the correct BI Role BI Administrator - Can edit, modify dashs, reports and RPD BI Author - This guy can create content, analyze and publish that on a dashboard BI Consumer - This can only view constructed contents Knowing that you can configure your dashboard or your…

Chandra, You can write SQL queries in OBIEE but it's not really a good way to make your reports by many points. If you want to create a report using directly database requests follow this: Directly Database Request Config How-to: Direct Database Request Configuration OBIEE 11g ~ Ask John OBIEE - Oracle Business…

Hi, Where did you find that? You don't answer me. Which OBIEE and OS version are u using? I'm thinking you're using a non-certified environment. This can your root issue. Felipe Idalgo

Hi, Do you have these information available trought RPD?

Hi, You got error because you're trying to use a AGG column on DataFilter. FILTER("Facts - AP Transactions"."AP Amount" USING ("Facts - AP Transactions"."No of Invoices Paid After Due" > 0)) Is above column ("MARKED") set to aggregate on RPD? If you have invoice by invoce on your fact table, could you use a detail column…