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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. amomar

    Setting up linked server to OLAP in SQL2005

    I seem to remember getting this as an erroneous error in the past on 2K. How can you tell that you're getting a response from AS?
  2. amomar

    Setting up linked server to OLAP in SQL2005

    The way I'd access the cube is by sending MDX through Openquery from a proc: SET @nv_mdx = 'WITH SET [Days] AS ''''{[years].[time]}'''' SELECT {Days} ON 0, [Product].[Product].members DIMENSION PROPERTIES MEMBER_CAPTION, [Product].[Product Division ID] ON 1 FROM...
  3. amomar

    Setting up linked server to OLAP in SQL2005

    I'm having problems connecting to Analysis Services 2005 via a linked server. I'm selecting: Microsoft OLE DB Provider For Analysis Services 9.0 as the provider and also entering values for the data source and catalog. It wouldn't allow me to enter just these details and requested a product...
  4. amomar

    Report in Access Project Loses Rows

    I have a report which is based on an a stored procedure. This returns data based upon parameters supplied at runtime from a form. Results are usually returned within a few seconds. There are certain values which when passed as parameters cause the stored procedure to take longer (4 mins)...

Part and Inventory Search

Back
Top