Recent content by katams

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...

There doesn't seem to be support under the .net platform for ADOMD. Has anyone dealt with this? Thanks!