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!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by AjitG

  1. AjitG

    MDX Function Iif

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

    OLAP Server connections in Excel

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

    How can I do this in a single query?

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

    How can I do this in a single query?

    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)...
  5. AjitG

    How can I do this in a single query?

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

Part and Inventory Search

Back
Top