Reporting
Questions about Cube Views and Reports

Forum Posts

formulae is not working

The same formula works in a quick view sheet but errors out in member formaule on UD8.If (Not ViewMember.IsAnnotationTypeViewId(api.Pov.View.MemberId)) ThenReturn api.Data.GetDataCell("BWDiff(T#[Quarter(|WFTime|)]:U8#None,T#[QuarterPrior1(|WFTime|)]:...

OS_Pizza_2-1698776655112.png
OS_Pizza by Contributor III
  • 647 Views
  • 1 replies
  • 0 kudos

CubeView: Dynamic prior quarter increase/decrease

Hi!I am trying to do the following variance to calculate the incremental balance between 2 Qtrs but the time filter doesn't work:GetDataCell(Variance(CVR(Row8),CVR(Row8):T#PovPrior1)):Name(Incremental RWA EOP)Row 8 is also a CVR calculated row. I hav...

Resolved! import error

Hi, I am importing from the ERP i go the error intersection is read-only due to conditional input settings.when i click on load and transform i have this error. the transaction is related to IC account. when i changed the mapping to another IC accoun...

import error.PNG

IC Elimination Amount Ghosted

We see some ghosted elimination amount stuck at parent level and they keep getting carried forward to the rest of periods. The elim amounts are greyed out, but still get aggregated up along the entity rollup. Is there a way to stop the ghosted elim a...

Elimination Ghosted.jpg
yalixie by New Contributor III
  • 642 Views
  • 3 replies
  • 0 kudos