Hi, I have a button that runs a dashboard extender business rule.
Between the 4 server options available, which one should I choose when,
and should I even care about choosing the right one (i.e. when does it
make a difference)? Thank you
Hi all, how do you run an aggregation, i.e. calculate the "Aggregated"
member of the consolidation dimension, without running a consolidation?
In particular, would it be possible to setup the Process step of a
workflow profile so that it runs an aggr...
Hi, I know I could create a custom member list of an XFBR rule for the
scope, but is there an easier option to get the cube view rows ordered
alphabetically based on member names? Eg. currently, if I have
E#Ent1000.Children in row, the cube view is b...
Hi, I have a Bound List parameter with Command type SQL. 1. I have first
tried to use an XFBR rule within the string of the Like condition. This
works fine. 2. I have then tried to use the XFBR to return the full
condition "cvi.Name Like..." (see bel...
Hi, is there an BrApi command that returns the Application Currencies,
ideally as a list of strings? I would like to use the output, i.e. the
list of currencies, in an Extender business rule, where I need to loop
through them. Thank you
Ok, thank you both! I don't know why I expected a separate "Aggregate"
command to be there alongside the consolidate/force consolidate, but in
fact I have to consolidate on the Aggregated member!
The datatable exists within the data set business rule, so yes you can
run a query against it, but within its limit of existence, as for any
other variable, i.e. you cannot refer to it from other business rules or
outside the function or loop where i...
Hi @AndreaTout , there are a couple of old threads on IdeaStream which
have been closed on dark mode. Currently there is this one open which I
have kudoed, and that I can suggest to you: Dark Mode For Business Rules
and Assemblies code editing
HI, I suggest making the member dynamic calc, so that you can specify a
formula for both the V#Periodic and V#QTD cases. The stored formula is
not going to work: if you calculate on V#QTD, data calculated quarterly
will be allocated to the dependent ...