The same formula works in a quick view sheet but errors out in member
formaule on UD8.If (Not
I have 2 rows named row1 and row2.1. Row1 has two members namely A and
B.2. Row2 has three members namely C,D and E.Now, I want to add row1 and
row2 so that it sum all A,B,C,D and E.Will this work or will it just
take first 2 members(i.e A and C) of ...
A1=100,A2=200 -> Both are Revenue account type and doesnt have any
formula.D1=A1+A2 ->Account type and Formula type -> Both are
dynamicCalcD2->Account type and Formula type -> Both are dynamicCalcWill
the below formula works?D2=D1+100
We have deleted certain transformation rule under 1:1 and while
deleting, my other colleague was also updating the same transformation
rule group.All those rule are showing up in the validate step as an
error even though they are deleted.Error - > "U...
This was resolved using parametersDim param As String =
ViewMember.IsAnnotationTypeViewId(api.Pov.View.MemberId)) Then Return
How aboutRow1 = GetDataCell("A#A + A#B): Name("Operating income
(loss)")Row2 = GetDataCell("A#C + A#D + A#E): Name("Operating income
(loss)")I want to add Row1 and Row2 in another row called Row3 without
using the member filter?
@WillVitaleI am not sure if you are looking to display inverse rate in
the cube view cell. If yes, Check below1. Create two members under
Accounts or UD8 . That will be your choice of dimension. I am using
Account here .Make sure to put the account/F...
@Nitishkrish16 There are many ways to achieve this.For now i can think
of this-1. You can write a sql query using the data adapter to output
the records. Below example to extract unique members.Modify the query as
per your requirement.Check the dim t...