Hi @chillychin , Please check my response in the previous page. Let me know if that helps

Once again variables didn't refresh to our environments without the patch Patched environments worked fine Happy days

It's just 1 year anniversary But I think we now see the light at the end of the tunnel

I don't apply the patches but as far as I can see from the SR the link with the details provided is the below one Oracle Support Document 2338889.1 We cannot recreate the issue but we have environments that have been patched with the above patch and environments that haven't. The ones that haven't been patched faced this…

First test was successful. Environments without the patch didn't refresh but patched environment was ok. We will give it another try but I'm confident that we may have a solution

That's the answer I was afraid of but also expecting

Are you sure that you are doing this in a pivot and not a "normal" table?

No I totally clicked the hidden option for the attribute when editing the pivot table

Yes that's exactly what I am doing. Not complaining at all though, just asking if this cheat is possible

Yes I am using 12c version, it is fine with normal tables but I keep getting this in pivot tables. I assume this is not happening in 11g, as your examples are from that version.

Long story short because I have to apply different filters in two reports and I don't want to customise each measure by filtering it with 10 different filters because it kills the performance

If I put it in the "exluded" area then the results will be grouped and I don't want that. I want them to be split by the attribute. I want it to be hidden because for the requested report I had to split in 2 different tables and put them side by side and I don't want the attribute to be shown 2 times. I want the side by…

You mean to totally exclude the attribute from the table? No this is a totally different query unfortunately

It is hidden just for cosmetic purposes, that's why I am asking if it is possible to hide it by code, as I tried all the possible built-in options with no result Yes, when I use the hidden option for an attribute in a normal table the column is disappeared together with every formatting but is this possible in a pivot…

Same issue here again in all environments, will contact Oracle again, they'll give us back the same random answer and life goes on

@Joel Acha This morning after the daily refresh @Onkar Nath Tiwari The time period that this is happening is looking totally random but when it happens a lot of people with different implementations and in different places face the same issue. It has been raised a long time ago but we are not having an answer (one that…

Today same issue came up again. I am curious if this happened again to other users too. All of us have raised the issue in the past. Oracle should be worried that different users with different implementations face the same issue almost at the same time. They should acknowledge that it is more possible that there is a…

The quotes worked too. Below is a screenshot, the first column has the values getting back when adding the presentation variable in the filter (the sql has a [T95.columnname in ('2014-01', '2014-03')] statement) and the second one is the presentation variable after adding the quotes in answers (I suppose I had to use the…

Interesting. You are right, the presentation variable has two values separated by comma. I'll try to check what i can do with the sql and return to this thread if needed Thanks

It looks like it passes no value to the presentation variable as it expects one value and the between operator has two