GOALExport cube view to Excel with Landscape printing orientation.
METHODThere is a cube view setting on the Advanced tab, labeled as
Landscape = True/False. I have set that setting to Landscape = True.
RESULTAfter exporting to Excel, the cube view f...
I had the same question! This is what I found worked:1) In Data Sources,
point the Amount to a row validator column*. This will NOT be the debit
or credit amount column of data if that column might contain a zero for
a valid row.2) Update the 'Logica...
As Andy points out, you can create a Quick View to surface the entity
properties.Another quick and dirty answer is simply to:1. View the
Entity dimension in grid view.2. Display Parent Child Relationships =
Yes.3. Grid Columns To Display = Name, Pare...
CHOICE 1 You can move the scenario column after the account column to
trigger the repeating of the Actual label. But this may not be the look
you are going for.CHOICE 21. Make a UDx parameter of the Scenario and
Account names..2. Exclude header rows ...
This might help. I use a counting account called One. It is a dynamic
calc account with the formula: Return 1. I use it in reports. I might
report on entities E#West.Base and if I include the A#One account, it
will tally the number of members display...