KB274092: An error “More than one object with the name ‘Desc’ was found” is displayed during metric creation in MicroStrategy Web

• Strategy

An error “More than one object with the name ‘Desc’ was found” is displayed during metric creation when an object named “Desc” exists in the same project. This issue has been classified as a defect and a workaround is to create a metric in Developer or to rename the object.

SYMPTOM:
An error “More than one object with the name ‘Desc’ was found” is displayed during metric creation when an object named “Desc” exists in the same project. This issue has been classified as a defect and a workaround is to create a metric in Developer or to rename the object.

STEPS TO REPRODUCE:
Follow the steps below to reproduce this issue in the Strategy Tutorial project:

Create an attribute named “Desc”
In Strategy Web, create a OLAP function based metric such as RunningSum and specify “Descending” in the Sort By definition as follows.

Switch to the Fomula Editor and click the “Validate” button. The following error will be displayed.


More than one object with the name 'Desc' was found.

CAUSE:
This is a known issue in Strategy Web 10.0
The word “Desc” in “SortBy=(Category@ID Desc)” is an abbreviation of “Descending”. However, the validation process looks for objects named “Desc” and produces this error if found.

ACTION:
Users can upgrade Strategy to v10.3 to solve the issue.

WORKAROUND:

Rename the existing object from “Desc” to a different name
Create a metric in Developer

Comment

0 comments

Details

Knowledge Article

Published:

July 13, 2017

Last Updated:

July 13, 2017