Forum Discussion

Montreux's avatar
Montreux
New Contributor III
2 years ago

XFMemberProperty Property NumberOfNoInputPeriodsPerWorkflowUnit

Hi, I want to use the XFMemberProperty in a cube view to call the number of no input periods in a scenario.  This isn't returning a number though or anything.  I get an error. XFMemberProperty(DimT...
Cube View
  • ajackett's avatar
    ajackett
    2 years ago

    I think I may have just found the member property for the no input period, as I have it referenced in a business rule - WorkflowNumNoInputTimePeriods

    Good luck ğŸ˜€

ajackett's avatar
ajackett
New Contributor III
2 years ago

Hi Montreux, 

I stumbled across your post as I'm trying to do something similar - create a cube view for Forecast, where the YTD columns are the no input periods for Actuals, and the future months are inputs. 

I was just testing around to try and bind the month to a scenario. I don't have an answer for the property for the No Input Period, but an alternative which I've just tested is using the Text1 field. In my example for my FCT 1+11, I have 1 no input period - so I have put "1" also in Text1. 

This is the line I am using in the column member filter:

T#|WFYear|MXFMemberProperty(DimType=Scenario, Member=|WFScenario|, Property=Text1).AllPriorInYearInclusive

This shows columns for the YYYYM"Text1"

Let me know how you go.