Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Meta Data Services (MDS)
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- katams
- Thread
- Replies: 0
- Forum: NCR: Teradata
-
Top 10 List?
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... -
Alias Names?
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 -
Running Totals
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... -
Running Totals
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... -
Running Totals
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... -
ADOMD and ADO.Net
There doesn't seem to be support under the .net platform for ADOMD. Has anyone dealt with this? Thanks!
