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...
Thank you!
I also tried this to make it dynamic:
In my code I check to see if a member has children, and if so, I make it a hyperlink. So, if it has children, I'm going to display that along with the parent level, like this...
Select {[measures].[store sales], [measures].[sales count]} on...
Hi Issahar!
I tried what you said and it worked. I also tried the generate function:
SET [Rowset] as 'GENERATE ({[Sites].[MarketRegion].&[1]}, {[Sites].[MarketRegion].currentmember, [Sites].[MarketRegion].currentmember.children}) '
and that worked, as well. Do you use this function much...
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.