This is a duplicate of issue Please close this one

You can provide 100 more examples, more examples do not make this more clear. Logic is what we need. Define 'week of the month'

There is no such thing as 'week of the month' in a normal calendar . Please be specific if you expect an answer.

I would say simply add a column 'Month' to your data source that you can use as a filter? Not Sure what exactly you are trying to achieve and how the data differs.

Yes our system is also working correctly after this patch. Haven't had any issues since. Applying it should solve your issues

No, we do not have the patch installed. Will ask our guys to look into it, I do not control this myself unfortunately

Happened to us again last saturday

Please describe your data-model, If you have a proper time dimension set up (in your data-model as well as in BMM) then this shouldn't be an issue, you shouldn't have to use Descriptor ID to enforce use of index/partition.

Does this help you?: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=182692687424273&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=1998252.1

You can close the thread by marking one of the answers as correct. I think that should be your own answer in this case. However, you should first mark Roberts answer as helpful because he pointed you in the right direction

Think about it, A date does not uniquely identify year-month period. How do you expect this to work? You need to properly set up your date/period dimension and create the prompt on the column that contains the year-month.

You seem to abandon all the threads you start so why should we spend time helping you? EDIT: This was meant to be directed to the OP of course but he won't probably read it anyway.

Logically the queries are the same so they will always get the same results, I wouldn't worry about it to much.

No Problem, Haven't used smartview myself but it should enable you to get the best of both worlds

There's a great tool that has excel-like functionality. It's called Excel. If you want excel, use excel, you may want to look into smartview: Oracle Smart View for Office | Business Intelligence | Oracle

Robert Angel wrote: On BIPS again why use a good tool to deliver a sub-optimal result? Fully agree if you need trickery to do it, but if it's possible to do it with proper formatting, why not? Hence the link to the BIPS formatting document. BTW, of course I know you understand the rpad would disable aggregating, just…

Oops, seem to have missed you are already on a higher version . However, you should upgrade asap

Do you have bundle patch 11.1.1.7.140527 applied? http://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-ps6-1928219.xls Also you should upgrade to a newer version because support for 11.1.1.7 is at it's end.

Agree on not doing this in Analytics, however I think BIP is a good tool for this kind of 'pixel-perfect' requirements. rpad is one 'trick' to do it yes but there are caveats to this approach like not being able to aggregate the measures, so it all depends on the exact requirement.

Pretty sure this is not possible in Analytics unless you want to use 'tricks'. BI Publisher may be better equipped to do this, you can have a look at formatting options here: https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-7BD3C665-851A-43FE-BA2D-7501390D95AC.htm#BIPRD2554.