Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: apad
  • Content: Threads
  • Order by date
  1. apad

    NULL value treatment

    Hi I get a fact table with 2 key fields (1 key for Time dimension and 1 key for Product dimension) and 3 numéric fields for measures (MeasureA, MeasureB, MeasureC) Few records have the value NULL for the field MeasureC I create a Calculated Member with this formula : IIf(MeasureC is NULL...
  2. apad

    refresh/update a cube with VB

    Hi I would like to modify Calculated Member formula by a program. Is it possible with Visual Basic ? Is it possible to refresh a cube with a VB command ? Sample code would be appreciated. Thanks
  3. apad

    using variable in cube ?

    Hi I created a Calculated Member nammed PriceAfterTaxes = PriceBeforeTaxes x 0,196 I want to create several Calculated Member using Taxes Value (0,196 in this example) Can I create a variable "Taxes" with the value 0,196 and use it in the formulas of my cube ? My goal is to change only one...

Part and Inventory Search

Back
Top