In the meantime I can report some really great news about MDX Insert and my hope for it becoming the next "big thing" for Essbase.
I was working with a colleague on an ASO procedural calc. He was using 22.214.171.124.500 and ran into the "query exceeds 2^64" error which kills the calc. This was due to the large number of combinations in the POV.
The same calc in 126.96.36.199.031 doesn't give an error but it also never finishes.
The great news is that the same calc that died previously, when translated to MDX Insert, took a grand total of two seconds to complete in OAC. Two frikkin' seconds!
I'm seeking other outlines to try this on. If you've got one I can use for testing, drop me a line.
Also, I'll be at Oracle Open World 19 in San Francisco next week. I hope to see some of you there.
Post a Comment