Explore Data Report Example

This example shows a sample Explore Data report definition script:

  ReportType=ExploreData
  ReportDescription=Default Data Grid
  Scenario=Budget
  Year=2009
  Period=July
  View=<Scenario View>
  Entity=UnitedStates.Connecticut
  Value=USD
  Account=Sales
  ICP=[ICP None]
  Custom1=[None]
  Custom2=[None]
  Custom3=[None]
  Custom4=[None]
  Scenarios=Budget
  Years=2009
  Periods=
  Views=<Scenario View>
  Entities=Regional,UnitedStates.Connecticut
  Values=USD
  Accounts=GrossMargin,Sales
  ICPs=[ICP Top]
  Custom1s=[None]
  Custom2s=[None]
  Custom3s=[None]
  Custom4s=[None]
  ScenarioMemberList=[Hierarchy]
  YearMemberList=[Hierarchy]
  PeriodMemberList=[Hierarchy]
  ViewMemberList=[Hierarchy]
  ValueMemberList=[Hierarchy]
  AccountMemberList=[Hierarchy]
  ICPMemberList=[Hierarchy]
  Custom1MemberList=[Hierarchy]
  Custom2MemberList=[Hierarchy]
  Custom3MemberList=[Hierarchy]
  Custom4MemberList=[Hierarchy]
  RowDimensions=Account
  ColDimensions=Entity
  DisplayMode=Data
  MetadataDisplayMode=Labels
  Row=~-ExchangeRates
  Row=~-NetProfit
  Row=~-NetIncome
  Row=~-GrossMargin
  OBPSettings=0