Hi I have a method query that returns a data table of roughly 300k of
records. Is there anyway to export the result of the method query to a
csv file? I'm not keen on using a spreadsheet business rule or a grid
view on a dashboard given the volume of...
Hi all I was wondering if it is possible to override the default 'clear
and load' settings on a data load step from 'Level 2: Workflow Data
Unit' to 'Level 1: Cube Data Unit' Just to give a bit of context: We
perform a data copy from a Budget scenari...
Hi all What would be the best way to create an intersection of two
hierarchies within the same UD? For example, assume these are Profit
Centres in UD1. I would like to be able to create a cube view where by I
could choose a node from hierarchy 2 and ...
Hi Is it possible to configure default group settings for a grid view?
E.g. I've got a table here, and I'd like to configure the table so that
it is grouped by the message column: Regards, Mark
Hi I am using a column override formula in my cube view and I have
noticed that it doesn't work when I try override a column when the name
has spaces in it, even if I surround it in square brackets. Am I doing
something wrong? Regards, Mark
Have you configured flows for this accounts? I assume you are referring
to the the EndBal or equivalent member, that looks something like this?
If so, make sure the Switch Type is set to false. Else it will treat
those intersections a P&L (it will co...
Hi Andy What type of accounts are these? Typically you would expect the
accounts to translate based on their account type: and the cube
properties: What is the purpose of the comparison cube view? Are you
expecting the accounts to translate at closin...
@MarcusH thanks for this, I think it is exactly what we need! It's not
quite as simple as the first option 'Clear All Import/Forms Data from
Cube' because we have got seeded data in the scenario that we don't want
to clear out. But I'll look into the...
Hi Davide I think that we have done something similar to what you are
trying to achieve using an XFBR rule and a parameter. Parameter Config:
XFBR Rule: Public Function Main(ByVal si As SessionInfo, ByVal globals
As BRGlobals, ByVal api As Object, By...
