Why I created a blog

Its been four years since I first created this blog. It has remained true to Essbase and related information over those years. Hopefully it has answered questions and given you insight over those years. I will continue to provide my observations and comments on the ever changing world of EPM. Don't be surprised if the scope of the blog changes and brings in other Hyperion topics.

Thursday, February 5, 2009

Update on report script commands and more on ODTUG

I was looking through the tech reference the other day (9X) for something and noticed a couple of report writer commands that I had not seen before. They deal with using aliases or member names. AS you might remember we used to use {OUTMBRALT}, {OUTALTMBR}, {OUTALT}, {OUTALTNAMES}, OR {OUTMBRNAMES} sometimes with little success. You had to place one of these commands before the dimension you were defining in the report and change it before the next command if you wanted something different for the next dimension.

When they added duplicate member names, they created new commands
<REPMBR , <REPALIAS, <REPMBRALIAS, and <REPALIASMBR
They offer more flexabilitiy than the old commands. You can dfine multipe dimensions at once that share the same attribute.

For example if you want aliases for Product and Market you would specify
%lt;RepAlias "Product" "Market"

It should be noted you can't use these commands mixed with the old commands (exception bing to select the alias table <OutAltSelect) and you can't use them if you are using rename functions. There are additional commands to get fully qualified names, but by looking the above up in the tech reference you should be able to find them.

You may nave noticed I've been posting a lot about the ODTUG conference. I had a comment about me being crazy(well not as nicely put as that) to suggest that people pay for it themselves if their company won't. I really believe this conference adds so much value and knowledge that it is worth it. I paid my own way last year and would again if my boss were not so supportive. (an amazing compliment. Edward, don't get used to it)
If you need rational to present to your boss to compel him/her to let you go, I suggest looking at Gary Crisi's blog entry. http://garycris.blogspot.com/2009/02/some-tips-for-kaleidoscope-2009.html He has great tips on how to get this conference approved in these tight times.

1 comment:

Tey Brady said...

Five years later. Thanks for this post!

I was trying to mix rebmbr with the old commands. I changed to repalias for one dimension and got my aliases.