Blog Post

Community Blog
7 MIN READ

Cool CubeViews with Custom GetDataCell Functions

JackLacava's avatar
JackLacava
Community Manager
2 years ago
"Hey boss, look a this Cube View I made - it shows our EUR Fx rates against all currencies in our app. Cool, uh?" "FX rates we loaded last month aren't cool. You know what's cool?" "... You?" "...
Updated 2 years ago
Version 2.0
technical tips
MarkBird's avatar
MarkBird
Contributor III
2 years ago

Thanks Jack.

Little less than ideal, but I ended up getting around it by putting the same filter as Col1 into the formula:

GetDataCell(BR#[BRName=MyDynamicCalcs, FunctionName=CalculateCustomVariance, Col1=[V#YTD:S#Actual]...

 and then calling api.Data.GetDataCell() in the business rule:

Dim Col1 As String = args.DataCellArgs.NameValuePairs.XFGetValue("Col1", "")
Dim Col1Value As Decimal = api.Data.GetDataCell(Col1).CellAmount