Hi,
Please help.. I want a level in the dimension such that the concatenation of two columns in the dimension. Can I do that while creating the dimension or I have to do in the database level.
please answer urgent help..
Rajbest way to do it is at the relational level so it is ready for processing.
however, you can concatenate strings in MDX
this is an example of measure concatenation
LINK (http://www.databasejournal.com/features/mssql/article.php/10894_1550061_4)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment