Hi All, in OneStream 6.x some functions in Business Rules became
Obsolete. One of them is the BRApi.Database.GetCustomDataTable where the
initial script required a string as CriteriaExpression but now it
requires a list of dbWheres. That part I fixed...
Hi All, In OneStream there are many audit tables containing specific
sections that can be audited. I'm looking for a detailed overall data
audit showing which user changed which number at what time. Preferably
combining loads with (Excel) input. Does...
Hi all, In a CubeView we want to see selling and buying members in one
row. So for Column 1 is sales where the Entity is the selling entity and
IC is the retrieving entity. in the same CubeView Column 2 is stock
where the Entity is the Buying Entity ...
1. Log CleanerOneStream provides sophisticated and detailed audit trail
capabilities using various types of logging. The logging functionality
is distributed over the system and the Log Cleaner MarketPlace solution
provides a single interface to mana...
The XFGetCell function has 20 arguments, when you have a large sheet
(e.g. for data validation) there can be many of these functions
increasing the size of the excel file. In SmartView it was possible to
create 1 cell with commonly used arguments and...
Hi Manish, we did not compare it 1 to 1 but have quite a large sheet
which performs well so my current assumption is that there is no
performance issue using this approach. Let me know if you find out
Hi Sid, see below a working example, perhaps you can use this as a
reference: XFBR(BusinessRule, Function, RegID=|RegisterID|,
EndDate=[XFBR(TCR_ExtParamHelper, GetSumCustom, RegID=|RegisterI...
Just put square brackets around the inner XFBR [xfbr…(…)] that should do
it. When you get an error message the error is often showing the before
and after for your allocation method, there you can see which parameter/
variable was transformed correct...
Hi, the issue is that your business rule CG_StatisticalCalcs tries to
put a value in a parameter/ datatable/ object where the type of Decimal
is expected. However the number that is processes is too big to fit in
the Decimal specifications. Decimal i...