You could do something like this in your cubeView row
definition:GetDataCell(XFBR(CubeViewLists,GetSumMemberFormula,DimName=[|WFEntityDim|],MemberFilter=[E#Clubs.Base.Where(Text2
= Mfg)])):Name("Total Mfg Entities") And then in your Business Rules
XF...
Hello,I suspect this is a problem with having non-standard characters in
the Rule Name, such as an apostrophe.I strongly recommend ensuring
Transformation Rule names contain only a-z/A-Z/0-9 (and spaces seem to
be ok), but certainly no apostrophes or...
Public Class MainClassPrivate dctLastMemberName As New Dictionary(Of
DimTypeId, (Integer,String))Private Function GetMemberScript(ByVal si As
SessionInfo, ByVal cpk As DataBufferCellpk) As StringDim sb As New
Text.StringBuilder(1000)For Each dt As Di...
You could use the FDX for a DataUnit (FdxExecuteDataUnit) instead of a
CubeView, however that would always return base-level intersections. You
would have to aggregate from the DataTable using a SELECT SUM / GROUP BY
type query to perform the aggrega...
I can't tell you why the snippet won't work in your particular
application since we don't have the time and resources to provide
end-to-end consulting support (not without a Statement of Work anyway)
and learn the context within the application, whic...