Query Designer for AS2000

Hello,
I've installed new CTP June of SQL2005. And I'd like to create new report in
reporting services with connection to Analysis Services 2000.
So, I've created datasource, looks fine, test connection succeeded. When I'm
starting to create report, after selecting datasource, when I click on
"Query Designer"
I get following message:
"The query designer could not be loaded.
Verify your connection string and query string or enter a valid query to
continue."
Where is the problem?
Best regards
Piotr TrêbaczMake sure you add ConnectTo=8.0 to the connection string
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Piotr Trêbacz" <ptrebacz@.kruk-inkaso.com.pl> wrote in message
news:uJ8n5WvdFHA.2124@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I've installed new CTP June of SQL2005. And I'd like to create new report
> in
> reporting services with connection to Analysis Services 2000.
> So, I've created datasource, looks fine, test connection succeeded. When
> I'm
> starting to create report, after selecting datasource, when I click on
> "Query Designer"
> I get following message:
> "The query designer could not be loaded.
> Verify your connection string and query string or enter a valid query to
> continue."
> Where is the problem?
> Best regards
> Piotr Trêbacz
>|||> Make sure you add ConnectTo=8.0 to the connection string
It works, great, big thanks. I wonder why MS people didn't mention this when
I ask few times:)
Thanks again
Reagards
Piotr

Query Cube using SQL Select instead of MDX Select

In Analysis Services 2000, you can query cube using regular SQL Select command.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmpr/prsql_70e0.asp

Does Analysis Services 2005 support this feature?

Right now, I am using OpenQuery with MDX query to return Cube data into a SQL table:

select * FROM OPENQUERY(Olap_Linked_Server, '

select [Measures].[Sales] on columns, [Accounts].[Hierarchy].Members on rows from SalesCube')

But the result SQL table has long column names. How can I rename them?

Thanks,

Bo

Do your first insert into a temp table(TSQL) and rename the columns when you do the next insert to a second table, by using standard 'as', for renaming.

Regards

Thomas Ivarsson

Query could not be processed. Access is forbidden

I am using http to access my cube (MS Analysis Server) and there are users
who are getting "Query could not be processed. Access is forbidden"
intermittently. Can someone help out and let me know what is causing this
issue? Some users are not getting this error.Hi

Googling on this and it does not turn anything up directly, although there
does seem to be an underlying implication that is it either connectivity or
permissions that is causing "Query could not be processed.". Without more
details it is not possible to say more, but I suggest that you check the
usual sources for this type of problem, such as: number of connections on
the server, the reliability of the network to connect, if different users
can connect from the same machines, if the machines that can't connect are
using the same versions of software.

Further information may spread more light on this, such how is the
connection being made etc..

John

"Ramir Santos" <ramir@.optonline.net> wrote in message
news:qag3d.80$K85.18831@.news4.srv.hcvlny.cv.net...
> I am using http to access my cube (MS Analysis Server) and there are users
> who are getting "Query could not be processed. Access is forbidden"
> intermittently. Can someone help out and let me know what is causing this
> issue? Some users are not getting this error.
>|||John,
Thanks for spending time to answer my question.
as a followup, here are some of the details
1. we are using office web component to connect to the cube (office xp
sp 2)
2. 2 separate machine, 1 hosting our aspx and the other with Analysis
Services and IIS installed. Analysis services installed using developers
edition
3. we only have 5 users right now
let me know what other information you would need to help me out on
this. appreciate your time and effort!

"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:414daf9b$0$20644$afc38c87@.news.easynet.co.uk. ..
> Hi
> Googling on this and it does not turn anything up directly, although there
> does seem to be an underlying implication that is it either connectivity
> or
> permissions that is causing "Query could not be processed.". Without more
> details it is not possible to say more, but I suggest that you check the
> usual sources for this type of problem, such as: number of connections on
> the server, the reliability of the network to connect, if different users
> can connect from the same machines, if the machines that can't connect are
> using the same versions of software.
> Further information may spread more light on this, such how is the
> connection being made etc..
> John
>
> "Ramir Santos" <ramir@.optonline.net> wrote in message
> news:qag3d.80$K85.18831@.news4.srv.hcvlny.cv.net...
>> I am using http to access my cube (MS Analysis Server) and there are
>> users
>> who are getting "Query could not be processed. Access is forbidden"
>> intermittently. Can someone help out and let me know what is causing this
>> issue? Some users are not getting this error.
>>
>>
>>
>>
>>|||Hi Ramir

It looks like this may be the problem?
http://tinyurl.com/4obw5

John

"Ramir Santos" <ramir@.optonline.net> wrote in message news:<Qyp3d.150$gR1.273403@.news4.srv.hcvlny.cv.net>...
> John,
> Thanks for spending time to answer my question.
> as a followup, here are some of the details
> 1. we are using office web component to connect to the cube (office xp
> sp 2)
> 2. 2 separate machine, 1 hosting our aspx and the other with Analysis
> Services and IIS installed. Analysis services installed using developers
> edition
> 3. we only have 5 users right now
> let me know what other information you would need to help me out on
> this. appreciate your time and effort!
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:414daf9b$0$20644$afc38c87@.news.easynet.co.uk. ..
> > Hi
> > Googling on this and it does not turn anything up directly, although there
> > does seem to be an underlying implication that is it either connectivity
> > or
> > permissions that is causing "Query could not be processed.". Without more
> > details it is not possible to say more, but I suggest that you check the
> > usual sources for this type of problem, such as: number of connections on
> > the server, the reliability of the network to connect, if different users
> > can connect from the same machines, if the machines that can't connect are
> > using the same versions of software.
> > Further information may spread more light on this, such how is the
> > connection being made etc..
> > John
> > "Ramir Santos" <ramir@.optonline.net> wrote in message
> > news:qag3d.80$K85.18831@.news4.srv.hcvlny.cv.net...
> >> I am using http to access my cube (MS Analysis Server) and there are
> >> users
> >> who are getting "Query could not be processed. Access is forbidden"
> >> intermittently. Can someone help out and let me know what is causing this
> >> issue? Some users are not getting this error.
> >>
> >>
> >>
> >>
> >>