Search results for query: *

Please refer to the link from MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agmdxadvanced_82lh.asp Ajit

I use about 20-25 Excel files which connect to OLAP server and retrieve information from the cubes. Since I have set auto refresh on file open for all these files it does the job and serves my purpose. The problem I am facing : I have changed my OLAP Server from Server A to Server B. How do I...

Thanks again Terry & Brian. The query worked great. I have modified Terry's query to reflect the one that I am using in the live environment.I guess this will make things clear for everyone. I for one am not clear as to the use of RowNo Int Identity. If I remove this, the query goes for a...

Many thanks to Terry & Brian for suggesting different ways to solve my query. Unfortunately since I am not in the office I can not try this out. I will be checking this out tomorrow and will keep you guys posted on the results... And yes Brian - my requirement is as suggested by you i.e., (1)...

Hi, Data is extracted from a single table. On giving query on Trantype='IS' I get this output Ref KeyRef Product Quantity TranType I95 Q1 PF1 9 IS I95 Q1 PF2 12 IS I95 Q1 PF3 6 IS On giving query on Trantype='PR' I get this output Ref...