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

Lookup cubes > Lookup cube example—using rules

Lookup cube example—using rules

Lookup cube example—using rules All rules that utilize lookup cubes depend on the TM1 Rules DB function. Here is another lookup example: Surfboards are sold in different lengths. The price of each board will be based upon a different price per foot. A Cost cube holds information on the cost of surfboards; a lookup cube holds the price per foot reference data. A rule will be written to yield the total cost of each surfboard sold. The rule in the Cost cube might be as follows: ['Board Cost'] = ['Board Length']* DB('Cost',!Product,'PricePerFoot'); In this example, you can see that the reference cube might be the single source for pricing information in the TM1 application.

  

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