hi Mallikarjuna Kuppauru-Oracle, Thank you for your help. I have tested the option that you mention, and this is for expand the layout grid and this not affect to the pivot table: Thanks and regards. Pablo.

Hi!, Any option on this? Can you confirm if the pivot table with several columns and subtotals is not posible to show expanded by default? The client is asking me. Thanks and regards. Pablo.

Hi, I think we have not permissions for use EVALUATE function in OTM FTI version. There is a limited version if OBIEE. I get several errors. TIMESTAMPADD(…) is an option I was considering, the problem is that it is not always the same time difference, depending on the day of the year it can be +1 (from October to March) or…

Hi guys, The problem is that the OBIEE formula box doesn't accept Oracle DB functions. For example, the following functions transform the date into a specific format: But then when I try to put them in a similar way in the formula of the tool it does not accept the syntax and gives an error: I think the FROM_TZ function is…