Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Writing a Rule > GetCell Functions

GetCell Functions

While the HS.Exp writes data, the HS.GetCell function is used to retrieve data from the database. You will need to pull values from the database to either test if a number is valid, or to see if you should perform a rule. The most common way to use these numbers is to populate the variable with numbers:

Image

You can specify all of the same values you can for the HS.Exp on the right-hand side of the equal sign here too. You can use all 12 dimensions, mathematical operators, relative members, and other functions.

The following example assigns to the dData variable the amount stored in the intersection of the Sales account dimension:

Image

Some of the most common HS.GetCell functions not only pull data but also pull test values, so you can more easily test conditions. Other HS.GetCell functions pull special types of data.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint