Recent content by apad

I found a "solution". I created a Measure named MeasureCIsNull with the property Source Column = CASE WHEN "dbo"."FAITS"."MEASUREC" IS NULL THEN 1 ELSE 0 END I modified my Calculated Member like this : Iif(MeasureCIsNull = 1, MeasureA x MeasureB, MeasureA x MeasureC). I'm not proud but I...

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...

My real problem is to pass values to my cube. These values are like parameters which alter cube behaviour and results. They have only one value at a time. Tax is one of them, CurrentWeek is another ... Storing these values in Calculated Member and updating formula with Visual Basic seem to be...

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

I created Calculated Members "Taxes" (= 0.196) and "PriceAfterTaxes" (=PriceBeforeTaxes x Taxes). Now, can I modify the value of "Taxes" and refresh my cube by programming with Visual Basic ? An answer would be nice, a code sample would be great ... Thanks

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...