Thanks aabid and nlim :)
Actually in the lkp table there is a 1to1 relationship ,however, some of the descriptions are identical and that is why on my report, I only want to group by description. Another words, I would like to have all the id's group under the same descriptive name. example...
In a dimension table you have an id with a corresponding name. For Microstrategy Desktop, all of the attributes/metrics are linked by the ID. I would like to have the Select statement choose the id to do all calculations, but I want them to be Grouped by the name.
Is there a way to group by...
Created a new attribute in microstrategy desktop using nm form vs id. Schema was updated with no errors.
When attribute is placed on report as page by I receive an error message "Method '~' of object '~' failed".
Does anyone know what this means?
thanks in advance,
annie123
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.