Hi You can do it: In the year prompt, delcare a varable apresentation: In the data prompt make this: Example of querie sintax: SELECT cast("D01 - Data Apuração"."Data Inicial" as date) FROM "Evento" WHERE "D01 - Data Apuração"."Número Ano" = @{vYear} See the result: Note: Unfortunately this is only an workaround, when you…

Hi, Please tell us, what is the OBIEE version and if your user is Administrator System. Also, will good if you show a print screen to us. Regards, Carina Mendes.

Hi @Gianni Ceresa Actually the problem was dataype column in the table, but the error only appeared in OBIEE. How is not a adminsitrado environment only for myself, I can not say why this VARCHAR (4000) was set. Anyway, your help was of great value, thank you! Regards! Carina Mendes.

Hi, Mr. Christian Berg I changed the datatype in the database and the problem was solved! Thank you!

Hi Mr. @Gianni Ceresa, Yes, I'm using the 11.1.1.9 version of OBIEE. I made the adjustment that recomedou to varchar (100) forcing the application to bring a smaller number of characters in the column, but the error in OBIEE continues. Thanks, Carin Mendes.

Thomas Dodds "One who doesn't understand the fundamentals will fail with any tool" Very good, I completely agree!

Hi Mr. @Gianni Ceresa Yes, the error is show in OBIEE report: If I make an select in data base, I don't have this error: I thought it was some limitation of the base date of the RPD but found no configuration related to this problem. Thanks, Carina Mendes.

Hi Thomas, Thanks for your answer, but my user in OBIEE don't have acess this option in menu. Regards, Carina Mendes.

Hi, You can send us an picure of your report? I'll like understend better you and help you. Regards, Carina Mendes.

Thanks @cesar.advincula.o

Hi, I also tried using the native drill configured in hierarchies in my analysis with union, but they do not work. I believe the union changes the form of the metric aggregation and therefore lost this functionality for analysis with union. Good luck, let us know if you can, please! Regards, Carina Mendes.

Hi, May work if you change the date value by filter parameter. See the samples: 1) COUNT(FILTER("you colum with value" USING ("your colum due date" < date '2016-10-11'))) 2) SUM(FILTER("you colum with value" USING ("your colum due date" < date '2016-10-11'))) 3) COUNT(FILTER("you colum with value" USING ("your colum due…

Hi @Debraj, One of the features of the "Link action" lets you navigate to another report when you click the value or header (label) of a column. It is possible to do this regardless of the subject area. First larval you need to have two reports with the information "project cost" and another with the information of…

Hi Felipe! I did your process and got the enviroment with sucess. This help me! Thanks!!! Carina Mendes.

Hi, so: Already realized this implementation in different environments and had never encountered me with this error before. The environment I'm using A and B are equivalent. Thanks, Carina Mendes.

Hi @Christian Berg Thanks! I performed the procedure in this article: Migrating Security - Policy Store http://www.rittmanmead.com/blog/2011/04/oracle-bi-ee-11g-migrating-security-policy-store-part-2/