Building in Memory Data Cube that has Full Time Hierarchy

#1

I’m getting an error when I try to build my in memory data cube when I put a full time hierarchy on the data cube output. It builds fine on the same data cube that doesn’t have any full time hierarchies on it. Has anyone ever run across such an issue?

Below is the error I get-

Error: System.InvalidOperationException: Duplicated member found. Member Caption:‘C’ Unique name:‘C.A.IssueType’, level Caption:‘IssueType’ Unique name:‘A.IssueType’, hierarchy Caption:‘IssueType (CRSMap)’ Unique name:‘IssueType’
at Dundas.BI.AnalyticalEngine.Metadata.HierarchyMemberInfo…ctor(DataContainer dataContainer, IHierarchyMember member, Int32 key, Int32 ordinal)
at Dundas.BI.AnalyticalEngine.Hypergraphs.DataContainer.CreateMemberInfo(HierarchyLevelInfo levelInfo, List1 currentInfos, IHierarchyMember member, HierarchyMemberInfo parentInfo, Dictionary2 parentMembers)
at Dundas.BI.AnalyticalEngine.Hypergraphs.DataContainer.ProcessHierarchyLevel(IHierarchy hierarchy, HierarchyLevelInfo levelInfo, IHierarchyLevel prevLevel, Dictionary2 parentMembers, BuildTaskProgress progress) at Dundas.BI.AnalyticalEngine.Hypergraphs.DataContainer.ProcessHierarchy(IHierarchy hierarchy, GroupCancellationToken cancellationToken, BuildTaskProgress progress) at Dundas.BI.AnalyticalEngine.Hypergraphs.DataContainer.LoadHierarchyMembers(GroupCancellationToken cancellationToken, BuildTaskProgress progress) at Dundas.BI.AnalyticalEngine.Management.AnalyticalEngineManagerService.BuildHypergraph(DataCube dataCube, Nullable1 tenantId, GroupCancellationToken cancellationToken, BuildTaskProgress progress)
at Dundas.BI.AnalyticalEngine.Management.AnalyticalEngineManagerService.Build(Guid dataCubeId, GroupCancellationToken cancellationToken, BuildTaskProgress progress, Boolean ignoreParameterValidation)
at Dundas.BI.AnalyticalEngine.Management.AnalyticalEngineManagerService.<>c__DisplayClass10_0.b__0()
at Dundas.BI.Services.CallerContextService.<>c__DisplayClass25_01.<SpawnTask>b__0(Object state) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Dundas.BI.TaskExtensions.WaitNoAggregateException(Task task, CancellationToken cancellationToken) at Dundas.BI.Data.Jobs.InMemoryCubeStorageJob.ExecuteInMemory(JobRunContext runContext, DataCube cube) at Dundas.BI.Data.Jobs.InMemoryCubeStorageJob.Execute(JobRunContext runContext) at Dundas.BI.Scheduling.JobService.RunJobSync(Session runBySession, Job job, Action2 setJobRunId, CancellationTokenSource cancellationTokenSource)
at Dundas.BI.Scheduling.JobService.<>c__DisplayClass36_0.b__1()

No views depend on this data cube.

#2

This doesn’t seem related to the time dimension, as I can see a totally different user hierarchy being referenced here. This error would seem to indicate that the key source for your user hierarchy’s child level has duplicating members.

For the user hierarchy referenced her e(issue type) are you using an id field or a string field as your member key source on the child level? It’s generally recommended that the id field is used as strings might not always be consistent and can sometimes inadvertently lead to duplicates when similar strings with different formatting considerations are a factor.