I'm trying to add a measure group dimension with a relationship type of fact.
It looks like this is a
DegenerateMeasureGroupDimension

I've added it with AMO and the results look OK.
It doesn't show up the same was as a manually created one in the cube
dimension usage panel.
It's saying "a fact dimension has been created in a way the user interface
does not support".

Is there an AMO Example for DegenerateMeasureGroupDimension

Hi,

Currently I did not find and sample code for
DegenerateMeasureGroupDimension class. Will you provide the code you use to
create this dimension? I will try to reproduce the issue on my side.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Hi,

it's generic code (driven for metadata stored in tables)
Let me know if the following isn't enough

'Dimension may have already been added when processing another
measure group
'If the dimension is already there use it
Try

objCubeDim = objCube.Dimensions.FindByName(strDimName)
If objCubeDim Is Nothing Then
'Add Dimension to the Cube
objCubeDim = objCube.Dimensions.Add(objDim.ID)
objCubeDim.Name = strDimName
End If
Catch ex As Exception
FlagError("Failed CreateCubeDimension. Can't Add " & strDim, "Y")
Return
End Try
Try
' Have to create appropriate object based on relationship type
If strRelationshipType = "Fact" Then
'Fact relationship so use DegenerateMeasureGroupDimension
Dim objMGFactDim As New DegenerateMeasureGroupDimension
objMGFactDim.CubeDimensionID = objCubeDim.ID
' add to the measure group
objMeasureGroup.Dimensions.Add(objMGFactDim)
objMGA = objMGFactDim.Attributes.Add(objDim.KeyAttribute.ID )
objMGA.Type = MeasureGroupAttributeType.Granularity
'Add Key
objMGA.KeyColumns.Add(strMeasureGroupTable,
strMeasureGroupKey, OleDbType.WChar)
Else


"Peter Yang [MSFT]" wrote:

Hi,

I was not able to use the code to createa Degenerate Measure Group
Dimension at present. I will perform some more research and get back ASAP.

Also, I suggest that you right click the manully created fact
dimension->Script demension as->Create to->New query editor Window and
check attributes of the dimension you need. Thanks.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Hi,

Did you mean
right-click on right-click on the measure group?
If so the XML looks the same for the manually created
DegenerateMeasureGroupDimension and the one generated through AMO. I assume
this means it works OK (looks like it is) but Business Intelligence
Development Studio isn't handling something created with AMO?

Thanks

"Peter Yang [MSFT]" wrote:

Hi,

Thank you for your patience. Based on the feedback from product team. This
error message "a fact dimension has been created in a way the user
interface does not support".happens when the table of the dimension is not
the same with the dimension of the measure group, or when the granularity
attribute is not the key attribute of the dimension. You may want to check
this to see if it helps. Have a great day!

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
<4FCCCDA1-6BCC-40B0-A4A5-0C270599BB1F (AT) microsoft (DOT) com>
<nMKiiS26FHA.832 (AT) TK2MSFTNGXA02 (DOT) phx.gbl>

Hi,

The following code is for just for your reference and there is no warranty.

Dimensions dimension = cubeDimension.Dimension;
DegenerateMeasureGroupDimension msrGrpDim =new
DegenerateMeasureGroupDimension();
msrGrpDim.CubeDimensionID = cubeDimension.ID;

MeasureGroupAttribute mgrGrpAttr=new
MeasureGroupAttribute(dimension.KeyAttribute.ID);
mgrGrpAttr.Type=MeasureGroupAttributeType.Granular ity;
foreach (DataItem dataItem in dimension.KeyAttribute.KeyColumns)
{
DataItem dataItemOfMsrgGrpAttr = new DataItem();
CopyDataItem(dataItem, dataItemOfMsrgGrpAttr);
mgrGrpAttr.KeyColumns.Add(dataItemOfMsrgGrpAttr);
}

msrGrpDim.Attributes.Add(mgrGrpAttr);

measureGroup.Dimensions.Add(msrGrpDim);

/// <summary>
/// Method is used in creation of bindings for measure group attributes.
/// The goal is to keep in sync the type and size of the bindings between
/// key column bindings of the dimension attribute and key column bindings
/// of the measure group attribute.
/// </summary>
/// <param name="dataItemSrc">Source data item. Normally the one from the
attribute key columns.</param>
/// <param name="dataItemDst">Destination data item. Normally the one to be
stored in measure group attribute key columns.</param>
/// <param name="copyNullProcessing">If true then NullProcessing is copied.
Otherwise it is not copied.</param>
public static void CopyDataItem(DataItem dataItemSrc, DataItem dataItemDst,
bool copyNullProcessing)
{
NullProcessing nullProcessing = copyNullProcessing ?
dataItemSrc.NullProcessing : dataItemDst.NullProcessing;
dataItemSrc.CopyTo(dataItemDst);
dataItemDst.NullProcessing = nullProcessing;
}

public static void CopyDataItem(DataItem dataItemSrc, DataItem dataItemDst)
{
CopyDataItem(dataItemSrc, dataItemDst, true);
}


Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
<4FCCCDA1-6BCC-40B0-A4A5-0C270599BB1F (AT) microsoft (DOT) com>
<nMKiiS26FHA.832 (AT) TK2MSFTNGXA02 (DOT) phx.gbl>
<2B911DF7-36E8-4521-BC24-E97322D7AE44 (AT) microsoft (DOT) com>