Hi, With all such queries the best advice is speak to your Oracle Account Manager. You think the technology can be complex, wait until you see the licensing...

With SKU Code in your analysis shouldn't the result of the count always be 1? Also, why isn't this calculation pushed back to the rpd? I would try removing all but Fiscal Year and your count calc and try it again. Then add back the other fields (SKU Code last!) and see when your results go wrong. Also view the physical sql…

Hi, If I were you I would read around dimension hierarchies and the time dimension. I would then implement a physical table that has surrogate keys at Year / Quarter / Month / Date (if needed) levels. Your keys should ensure uniqueness at each level; i.e. 2016 / 201603 / 201608 / 20160823 NOT 2016 / 3 / Aug / 23. You then…

try , -1 where you currently have ,1

Yes, you do. And this is from memory, but check the connection settings also, I am fairly sure there is an allow writeback tickbox in the back end also... I don't have access to OBIEE here to check.

On 2 - the connection pool that you underlying table connects to in the rpd, it has been a while but I am fairly certain you have to configure there to enable writeback, as I usually create a specialised connection pool for the purpose.

Writeback is a fair old length of pipe. 1. check your user has rights 2. check the connection pool can writeback 3. check the insert in the associated file against the db to ensure the syntax is valid 4. check the field mappings in the associated file to the fields in your answers report correspond 5. Wonder why you are…

Try adding OBIEE as trusted site and ramping down the restrictions on trusted site.

Have you looked at the physical sql to see what is happening there? Is your answers presentation table, as opposed to pivot, where there can be extra logic applied over and above the 'base logic'?

Can you push the logic for YTD into the rpd and try it?

Nice workaround!

Unless you can drop the table reimport then you will have to create the new columns manually, online or offline.

I know you got your answer, so probably are not as bothered now... But 'on how to do this in the rpd'; - 1. Copy any of your existing measures that make up an element in the formula in the business model layer i.e. - Tran Amount - Including Reversals 2. edit the formula on the properties for the field and reflect your…

cf my previous comment that you would be better doing this in the rpd. But, if it must be answers, have you tried using the filter functionality in function editor to create the figures, you can nest filters to achieve your ends. Or, what happens if you keep the DR / CR field but use display:none to suppress it, then pivot?

And how do you get the 'ears' of the product managers? I have worked for a number of blue chips but I have yet to see the client who actually influences Oracle, do they live next to Larry in the bay?

No, this functionality does not exist. This would be one of my pet niggles. The flat lists that provide no clue as to level in the hierarchy make Essbase in OBIEE not a great option, so much so that I once resorted to full data and metadata extracts / import to Oracle DB to provide the kind of functionality you would hope…

Whilst you can 'pin' a measure to as many dimension hierarchies at whatever level you need I would caution that you may find that the numbers may not be correct if you have a dynamic data population. i.e. if you form has prompts/ filters you may find that the level based measure does not produce the right figures, but your…

Whenever there is a combination of case and summation logic my best recommendation is to put it in a physical calculation in the subject area in the rpd. If this is not an option then sum(case... etc as recommended by @Asim should work, but you may also need to set the properties on that column to server complex aggregate…

Yes, that is all you need to do, assuming all passwords remain the same between the two environs...

RPD is the pre-requisite for the catalog, but as long as you have both in place before you try to use it then no worries. On 11g when you provide a path to your rpd it uploads a copy to the OBIEE server, so no.