This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
Respond to this messageReturn to Index
Original Message
  • Have you looked at @XWRITE?
      • Cameron Lackpour
      Posted Mar 15, 2011 10:58 AM

      If you're on 11.1.2, it might help with the block creation.

      Otherwise you're in the block creation game.

      I see that you aren't restricting the FIX by Scenario, Version, Year (I am guessing that this is Planning under the covers hence the dimensions). You could definitely reduce the scope of what you're trying to bring across.

      What I typically do with this requirement is make the target member stored. Yes it can be done in Planning with a HSP_NOLINK UDA. See: http://www.network54.com/Forum/58296/message/1271099076/How+to+kill+xref+formulas

      You have a bunch of choices at that point re block creation. Search this board for examples of SET CREATEBLOCKONEQ and SET CREATENONMISSINGBLKS. Watch out for that second one -- it works but is extraordinarily expensive because it evaluates every potential block.

      Regards,

      Cameron Lackpour
    Login Status
  • You are not logged in
      • Login
      Password
       

      Optional
      Provides additional benefits such as notifications, signatures, and user authentication.

      Create Account
    Your Name
    Your Email
    (Optional)
    Message Title
    Message Text
    Options Also send responses to my email address
          



    RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.