Error: Missing attribute GL_Detail_F_Trans.TimePeriod

Summary:

User received an error when running a report on Data Warehouse after upgrading to 4.6.6.

Symptoms:

Missing attribute GL_Detail_F_Trans.TimePeriod

RETRIEVE

  [None_GL_Detail_F_Trans_TimePeriod] : MAX([GL_Detail_F_Trans].[TimePeriod], ORDER),

  [Sum_GL_Detail_F_Trans_Value1#RFC12M] : SUM([GL_Detail_F_Trans].[Value1](RFC12M))

CONDITION

  (

  [d_Scenario].[Code] IN ('ACT')

  )

  AND

  (

  [d_dim0].[Code] IN ('22000')

  )

  AND

  (

  [Period].[PeriodId] IN ('201812')

  )

OneStop.Framework.RqlParser.RqlException: Missing attribute GL_Detail_F_Trans.TimePeriod

   at OneStop.Framework.Engine.RqlQuery.GetSql(ReportEnvironment env, DatabaseConnection conn, RParser parser)

   at OneStop.Framework.Engine.RqlQuery.ProcessCommand[T](ReportEnvironment env, Func`5 dataRetriever)

   at OneStop.Framework.Engine.RqlQuery.GetRawData(ReportEnvironment env)

   at OneStop.Framework.Engine.TableSource.GetData(ReportEnvironment env)

   at OneStop.Framework.Engine.Selection.SelectionGroup.DoQuery(SourceEnvironment senv)

   at OneStop.Framework.Engine.Selection.GroupMapping.FetchData()

   at OneStop.Framework.Engine.Selection.InstanceMatrix..ctor(SourceEnvironment senv, DefinitionItemCollection items, Boolean generateDrilldown)

   at OneStop.Facade.Execute.BuildLayout(ReportEnvironment env, LayoutDefinition ld, Boolean generateDrilldown)

   at OneStop.Facade.Execute.GetInstance(ReportEnvironment env, ExcelMapping exmap, String title, String sheet, Boolean generateDrilldown)

   at OneStop.Facade.Execute.

   at System.Linq.Enumerable.

   at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)

   at System.Collections.Generic.List`1.AddRange(IEnumerable`1 collection)

   at OneStop.Facade.Execute.ExecuteReport(ReportDefinition def, ParameterValueCollection values, Boolean generateDrilldown, String dictionaryName, Boolean checkLookup)

   at OneStop.Facade.Reporting.ExecuteReport(String reportId, ParameterValueCollection values, String dictionaryName, String clientIPAddress, Boolean checkLookup)

   at OneStop.Facade.Reporting.ExecuteReport(String reportId, ParameterValueCollection values, String dictionaryName, Boolean checkLookup)

   at OneStop.StandaloneAdapter.ReportEngine.

   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)

   at OneStop.Toolkit.Threading.ExtendedBackgroundWorker.OnDoWork(DoWorkEventArgs e)

   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

Cause:

This is due to the field was originally was pulled from incorrect dimension causing this error. 

Resolution:

Redrag the period to replace this GL detail period that is causing the error from all groupings and filters in layout editor and any other place on the report that would cause it. 

Properties:

Applies to:

• Report Designer 4.6