User Profile

rhankey

Contributor III

Joined 4 years ago

155 Posts79 Likes22 Solutions

View All Badges

User Widgets

Contributions

Re: Filtering account by UD's
More specifically, does the source data reside in A#61550:U2#Dept48? If so, check the Cell POV Information in the Cibe View using the Dynamic Calc account and that of where the source data resides. ...
4 days ago Place Reporting
25Views
0likes
1Comment
Re: How to get two decimal places in Member formula
Well, then it is time to dump out the second data buffer to error log to see why you are getting zero. You could be encountering a constraint issue. Also dump out the value of Var1, as perhaps it i...
18 days ago Place Application Build
20Views
0likes
0Comments
Re: How to get two decimal places in Member formula
In short, the error you are getting is because you are attempting to concatenate a Decimal datatype without any conversion into a String. The simple fix would be: api.Data.Calculate("A#520000 = A#4...
20 days ago Place Application Build
42Views
1like
2Comments
Re: Reporting expenses as negative instead of positive
This is readily addressed by creating a dynamically calculated U8#NaturalSign member, which flips the sign of Expense and Asset AccountType's.
23 days ago Place Reporting
56Views
1like
1Comment
Re: help with a conditional statement
If you need to be performing the test of JTDRevenueLoaded at each base UD1, then I would: Use an Eval2() in a single Calculate() statement, passing in current month JTDRevenueLoaded and prior month...
24 days ago Place Rules
12Views
0likes
1Comment
Re: How to get the sum of multiple entities in a GetDataCell or in a Calculate
I would loop through the applicable entities, and either perform two GetDataCell()'s/entity, accumulating to a grand total Numerator & Denominator, or get a single filtered DataBuffer/entity, from...
25 days ago Place Rules
25Views
1like
0Comments
Re: How to get the sum of multiple entities in a GetDataCell or in a Calculate
There is a whole lot going wrong in your first code fragment. The most glaring of which is that you are attempting to include a member expansion within an intersection. If you want to use GetDataCe...
25 days ago Place Rules
40Views
0likes
2Comments
Re: Get list of base members where text = in vb
GetMembersUsingFilter() returns a list of zero or more members matching the filter. Perhaps the following will get you going in the right direction: Dim members As List(Of MemberInfo)=api.Members.G...
25 days ago Place Rules
51Views
0likes
1Comment
Re: Referencing business rule in data management step
What Source Code Type is the File you are calling? The syntax for how you are calling the Assembly File looks fine for an Execute Business Rule step. However, you will get that error if you are not...
2 months ago Place Workflow and Data Integration
35Views
0likes
0Comments
Re: Syntax to pull entity description where entity NOT the POV entity
Good. It sounds like you were circling the solution. DimType.Entity.Id and DimTypeId.Entity are two methods that give the same result. There are a number of other similar redundancies in the OS ap...
2 months ago Place Rules
6Views
0likes
0Comments

Groups

No places to display