Issue 4474: CWM model needs to be augmented to allow specification of level& hierarchy Attribute.initialValue incorrectly implemented as mandatory. (cwm-rtf) Source: Oracle (Mr. David Mellor, david.mellor@oracle.com) Nature: Enhancement Severity: Significant Summary: The CWM model currently defines the physical mapping of a Cube based only on a level of a dimension. The model needs to be augmented to allow the specification of both a level and a hierarchy. Resolution: Add a new sub-type of MemberSelectionGroup which contains a reference to a hierarchy Revised Text: Added a definition of HierarchyMemberSelectionGroup to the OLAP Chapter in the CWM specification (formal/2001-10-01). This consists of the following additions of new text to the OLAP specification chapter: Modification Added a reference pointing to HierarchyMemberSelectionGroup, as part of the definition of Hierarchy. The new text is: hierarchyMemberSelectionGroup References HierarchyMemberSelectionGroups that are based upon this Hierarchy. class: HierarchyMemberSelectionGroup defined by: HierarchyMemberSelectionGroupReferencesHierarchy::hierarchyMemberSelectionGroup multiplicity: zero or many inverse: HierarchyMemberSelectionGroup:hierarchy Modification Added the definition of the HierarchyMemberSelectionGroup class. The new text is: 11.x.x HierarchyMemberSelectionGroup This subtype of MemberSelectionGroup allows users to specify that a particular cube region is determined by hierarchy. This allows the description of data to vary by hierarhcy and, therefore, provides the ability to model multiple measure values per hierarchy. Superclasses MemberSelectionGroup References hierarchy References the Hierarchies that this HierarchyMemberSelectionGroup is based upon. class: Hierarchy defined by: HierarchyMemberSelectionGroupReferencesHierarchy::hierarchy multiplicity: one or more inverse: Hierarchy::hierarchyMemberSelectionGroup Constraints Each Hierarchy referenced by a HierarchyMemberSelectionGroup must have precisely one corresponding MemberSelection (of the same Dimension) in the HierarchyMemberSelectionGroup's collection of MemberSelections. [C-15] Modification Added the definition of the HierarchyMemberSelectionGroupReferencesHierarchy association relating Hierarchy and HierarchyMemberSelectionGroup to the references section of Hierarchy 11.4.10.2. The new text is: HierarchyMemberSelectionGroupReferencesHierarchy A HierarchyMemberSelectionGroup references one or more Hierarchies. Ends hierarchyMemberSelectionGroup The HierarchyMemberSelectionGroups referencing one or more Hierarchies. class: HierarchyMemberSelectionGroup multiplicity: zero or more hierarchy The Hierarchies referenced by one or more HierarchyMemberSelectionGroups. class: Hierarchy multiplicity: one or more Modification: Added the definition of constraint "C-15" on HierarchyMemberSelectionGroup. The new text is: [C-15] Each Hierarchy referenced by a HierarchyMemberSelectionGroup must have precisely one corresponding MemberSelection (of the same Dimension) in the HierarchyMemberSelectionGroup's collection of MemberSelections. contextHierarchyMemberSelectionGroup inv:self.hierarchy->forAll( h | self.memberSelection->exists( m | m.dimension = h.dimension ) ) inv:self.hierarchy->size = self.memberSelection->size Replaced the existing diagrams of Figure 11-1 , Figure 11-2 , and Figure 11-3 with new diagrams showing the new HierarchyMemberSelectionGroup class and its attendent associations and references. The diagram of Figure 11-4 did not need to be changed. The old and new diagrams are as follows: Actions taken: August 7, 2001: received issue May 13, 2002: closed issue Discussion: End of Annotations:===== From: webmaster@omg.org Message-Id: <200108071538.f77Fcpt10620@emerald.omg.org> Date: 07 Aug 2001 11:42:10 -0400 To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Subject: Issue/Bug Report Content-Type: Text/html; charset=windows-1252 X-UIDL: o52e9~_E!!$&h!!~@Xd9 Name: David Mellor Company: Oracle mailFrom: David.Mellor@oracle.com Notification: No Specification: CWM Section: 4.4.6 FormalNumber: AD/01-02-01 Version: 1.0 RevisionDate: 02/01/2001 Page: 396 Nature: Enhancement Severity: Significant HTTP User Agent: Mozilla/4.51 [en] (WinNT; U) Description The CWM model currently defines the physical mapping of a Cube based only on a level of a dimension. The model needs to be augmented to allow the specification of both a level and a hierarchy. Date: Tue, 21 Aug 2001 16:26:04 -0400 From: David Mellor Organization: Oracle Corporation X-Mailer: Mozilla 4.51 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: cwmrtf Subject: Re: issue 4474 -- CWM RTF issue References: <4.3.2.7.2.20010813180244.04c5f260@emerald.omg.org> Content-Type: multipart/mixed; boundary="------------E6BFF755C71337DAEA855A93" X-UIDL: bcN!!kYMe9UX$!!n~3!! All, Attached is a new cat file for the olap package to resolve this issue. The proposed resolution is a new type of memberSelectionGroup called HierarchyMemberSelectionGroup that will allow the specification of the cube region to be by both level and hierarchy. Regards, Dave M. Juergen Boldt wrote: > This is issue # 4474 David.Mellor@oracle.com > > CWM model needs to be augmented to allow specification of level& >hierarchy > > The CWM model currently defines the physical mapping of a Cube based >only > on a level of a dimension. The model needs to be augmented to allow >the > specification of both a level and a hierarchy. > ================================================================ > > Juergen Boldt > Senior Member of Technical Staff > > Object Management Group Tel. +1-781 444 0404 ext. 132 > 250 First Avenue, Suite 201 Fax: +1-781 444 0320 > Needham, MA 02494, USA Email: juergen@omg.org > URL: www.omg.org > > ================================================================ [] Olap.cat [] David.Mellor.vcf