Anyone have much experience setting up Meta Data Services? I have the dsn for the repository database and repository database set up, but I'm getting errors with adding a system.
Any help would be greatly appreciated.
Thanks
I have a region dimension and geography dimension that I'm trying to generate a top 10 list from...
Example:
Region 1 Top City 1 Top Zip 1
Top Zip 2
Top City 2 Top Zip 1
Top Zip 2
Top Zip 3...
Region 2 Top City 1 Top Zip...
Is there anyway to alias a result in mdx? For example, in SQL, you can alias column names like
select colSomething as "Anything"
from tblSomething
I am trying to display averages and totals. I think I have the totals; it's the averages I'm having trouble with.
For example
Year 2000 Year 2001 Averages
AllStores 100 $100,000 10 $1,000 55
Store A 25 $10,000 3 $500 14...
I am tryng to display totals on the top row of any view when browsing a cube in asp.
For example:
The first view is:
Count Sales
AllStores 100 $100,000
When you drill on stores, it looks like this:
Count Sales
Store A 25 $10,000...
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.