Hello Cesar, Thanks for your response. I found something like that at MOS, anyway thanks a lot for your time and help. Felipe Idalgo

Hi, ++Other way You could create a formula for testing your selections or create a new variable prompt with the options Fiscal Year and Fiscal Period and based on this selection change your calculations, like that: Case when '@{var_time}' = 'Fiscal Year' then <put your columns or calc here> when '@{var_time}' = 'Fiscal…

Hi, Did you refresh your metadata and re-run your analisys after RPD change? Felipe Idalgo

Hi Christian, Thanks so much for your response. Felipe

Hi, Where did you store your XML template?

Hi, Where did you store your XML template? Verify if your user has acess to writeback function. On browser go to administration tab and click in manage privilegies (you need an admin user). At the end of the page you'll see writeback privilegies After perform that, restart OPMN and clear your browser (cache) Felipe Idalgo

Hi, Follow answers 1: Schema Name and table mentioned here POD.PO_DETAILS Ok, that's right 2: The column names like 'Sup Info', 'PO Number','Organization etc are from Presentation layer. Do I need to give database column names or Presentation Layer Column name? For example: - PO Number is stored in database column PO_NUM…

Hi, Can you or Can't you log into it? Provide more details about that, like if you could connect before, all your services are up and running and so on Felipe Idalgo

Hi, Please post here your sesion log. If you have physical cache implemented on your system, You can be quering cache files instead of your physical datasource. Try that: 1 - Purge your cache files; 2 - Execute your report once again 3 - Go to Session and take a look on your file Felipe Idalgo

Hi, It isn't possible 'cause OBIEE 12c doesn't have ORACLE DISCOVERER METADATA CONVERSION ASSISTANT To achieve that you should: 1 - Migrate Discoverer 10g (10.1.2.x or +)/11g to OBIEE 11.1.1.7.X or + first; Article: Migrating Oracle Discoverer Data to Oracle Business Intelligence 11g 2 - So you could migrate OBIEE 11g to…

Hi Kalpana, See if it helps you You'll need of these objects: 1 - A Graph View 2 - A Narrative View So, follow these steps: 1 - Add both views on your Compound Layout (For Example Graph above Narrative View) 2 - See that each object has its own border, you have now to set that as You want 3 - Graph View - Set up border on…

Hi, Post here a screenshot of your logical and presentation hierarchy with all levels from your PROD env. Felipe Idalgo

Hi, If you wanna copy roles from other environment, you can do: 1) Create that manually, follow that https://docs.oracle.com/middleware/1221/biee/BIESC/authentication.htm#BIESC594 2) Copy this roles from other environment trought "BI Export Bundle" (i don't know if you can copy only app roles) 3) "I never tested that"…

Hi, "View Selector" serves to swith between 2 or more objects. If you need to show one, 2, 3 views and so on without possibility to swith betweet them you can remove your "View Selector" and publish that on Compound Layout Note that all your available views are in view panel located on your left side Felipe Idalgo

Hi, See that https://docs.oracle.com/middleware/1221/biee/BIESC/authentication.htm#BIESC5978 When you install your OBIEE 12c environment you can configure a "blank" enviroment, namely, you have only BIServiceAdministrator available, other roles must be created according you need, or you can configurate a domain with…

Hi, Look that I did a test here to explain other possibility I created a table like that create table teste_felipe ( store number, prod number); And then add some lines insert into teste_felipe values (1,2); insert into teste_felipe values (2,1); insert into teste_felipe values (2,2); insert into teste_felipe values (1,1);…

Hi, Why do you need to use that? You could use a simple filter like that: Store Number in (100, 2) AND Product Number in (100, 3) AND Amount by Store > 10 OR Amount by Product > 10 If you wanna to see all values in a single column you could use a multi-value column Follow that if you really need, sincerly I would choose…

Hi, This feature basicly takes your custom descriptions and names from a database table or other repository you can read and set that for a presentation object (table, columns an so on...) You can have issues with your language key, verify your query you're using to populate your "Session Variable with Row Wise…

Hi, Go to Weblogic Console and See if you have anything down on "Deployment" tab Question: Is this a new installation? Did you try to restart all environment (Weblogic, NodeManager, Managed Servers and OPMN) ? Felipe Idalgo

Hi, I can't undestand your request What should do your hyper links? Post a screenshot of your dashboard here Felipe Idalgo