cannot see the view

Hi ,
I have created a login id on 2 different databases DB_A & DB_B as the owner
from crystal report i can see the view of DB_A but not DB_B using the same
login id
Could anyone kindly advise ?
tks & rdgs
Your post is not clear.
What is the default database for the login? Is Crystal connecting to DB_A?
If so it will be able to see the view in that database. Unless you "tell"
Crystal to look within DB_B for the view it will not be found.
Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
UserNameGoesHere
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> Hi ,
> I have created a login id on 2 different databases DB_A & DB_B as the
> owner
> from crystal report i can see the view of DB_A but not DB_B using the
> same
> login id
> Could anyone kindly advise ?
> tks & rdgs
|||Hi Keith ,
the default db for the login is master. and i have set up 2 odbc
datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
from crystal when connecting using DS_A it can show me the view but not when
using DS_B
i hope this time i am clearer in my explanation
i'll try to use the grant select on the view for that login in DB_B
tks & rdgs
"Keith Kratochvil" wrote:

> Your post is not clear.
> What is the default database for the login? Is Crystal connecting to DB_A?
> If so it will be able to see the view in that database. Unless you "tell"
> Crystal to look within DB_B for the view it will not be found.
> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
> UserNameGoesHere
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
>
>
|||Does Crystal "know" that the other view exists within the other database?
Can you tell it to look in the other database for the view? Sorry, I have
not used Crystal since version 5.
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...[vbcol=seagreen]
> Hi Keith ,
> the default db for the login is master. and i have set up 2 odbc
> datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> from crystal when connecting using DS_A it can show me the view but not
> when
> using DS_B
> i hope this time i am clearer in my explanation
> i'll try to use the grant select on the view for that login in DB_B
> tks & rdgs
> "Keith Kratochvil" wrote:
|||no worries Keith , tks for all the help given
Cheers,
maxzsim
"Keith Kratochvil" wrote:

> Does Crystal "know" that the other view exists within the other database?
> Can you tell it to look in the other database for the view? Sorry, I have
> not used Crystal since version 5.
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
>
>

cannot see the view

Hi ,
I have created a login id on 2 different databases DB_A & DB_B as the owner
from crystal report i can see the view of DB_A but not DB_B using the same
login id
Could anyone kindly advise ?
tks & rdgsYour post is not clear.
What is the default database for the login? Is Crystal connecting to DB_A?
If so it will be able to see the view in that database. Unless you "tell"
Crystal to look within DB_B for the view it will not be found.
Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
UserNameGoesHere
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> Hi ,
> I have created a login id on 2 different databases DB_A & DB_B as the
> owner
> from crystal report i can see the view of DB_A but not DB_B using the
> same
> login id
> Could anyone kindly advise ?
> tks & rdgs|||Hi Keith ,
the default db for the login is master. and i have set up 2 odbc
datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
from crystal when connecting using DS_A it can show me the view but not when
using DS_B
i hope this time i am clearer in my explanation
i'll try to use the grant select on the view for that login in DB_B
tks & rdgs
"Keith Kratochvil" wrote:

> Your post is not clear.
> What is the default database for the login? Is Crystal connecting to DB_A
?
> If so it will be able to see the view in that database. Unless you "tell"
> Crystal to look within DB_B for the view it will not be found.
> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere T
O
> UserNameGoesHere
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
>
>|||Does Crystal "know" that the other view exists within the other database?
Can you tell it to look in the other database for the view? Sorry, I have
not used Crystal since version 5.
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...[vbcol=seagreen]
> Hi Keith ,
> the default db for the login is master. and i have set up 2 odbc
> datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> from crystal when connecting using DS_A it can show me the view but not
> when
> using DS_B
> i hope this time i am clearer in my explanation
> i'll try to use the grant select on the view for that login in DB_B
> tks & rdgs
> "Keith Kratochvil" wrote:
>|||no worries Keith , tks for all the help given
Cheers,
maxzsim
"Keith Kratochvil" wrote:

> Does Crystal "know" that the other view exists within the other database?
> Can you tell it to look in the other database for the view? Sorry, I have
> not used Crystal since version 5.
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
>
>

cannot see the view

Hi ,
I have created a login id on 2 different databases DB_A & DB_B as the owner
from crystal report i can see the view of DB_A but not DB_B using the same
login id
Could anyone kindly advise ?
tks & rdgsYour post is not clear.
What is the default database for the login? Is Crystal connecting to DB_A?
If so it will be able to see the view in that database. Unless you "tell"
Crystal to look within DB_B for the view it will not be found.
Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
UserNameGoesHere
--
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> Hi ,
> I have created a login id on 2 different databases DB_A & DB_B as the
> owner
> from crystal report i can see the view of DB_A but not DB_B using the
> same
> login id
> Could anyone kindly advise ?
> tks & rdgs|||Hi Keith ,
the default db for the login is master. and i have set up 2 odbc
datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
from crystal when connecting using DS_A it can show me the view but not when
using DS_B
i hope this time i am clearer in my explanation
i'll try to use the grant select on the view for that login in DB_B
tks & rdgs
"Keith Kratochvil" wrote:
> Your post is not clear.
> What is the default database for the login? Is Crystal connecting to DB_A?
> If so it will be able to see the view in that database. Unless you "tell"
> Crystal to look within DB_B for the view it will not be found.
> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
> UserNameGoesHere
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> > Hi ,
> >
> > I have created a login id on 2 different databases DB_A & DB_B as the
> > owner
> >
> > from crystal report i can see the view of DB_A but not DB_B using the
> > same
> > login id
> >
> > Could anyone kindly advise ?
> >
> > tks & rdgs
>
>|||Does Crystal "know" that the other view exists within the other database?
Can you tell it to look in the other database for the view? Sorry, I have
not used Crystal since version 5.
--
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
> Hi Keith ,
> the default db for the login is master. and i have set up 2 odbc
> datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> from crystal when connecting using DS_A it can show me the view but not
> when
> using DS_B
> i hope this time i am clearer in my explanation
> i'll try to use the grant select on the view for that login in DB_B
> tks & rdgs
> "Keith Kratochvil" wrote:
>> Your post is not clear.
>> What is the default database for the login? Is Crystal connecting to
>> DB_A?
>> If so it will be able to see the view in that database. Unless you
>> "tell"
>> Crystal to look within DB_B for the view it will not be found.
>> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere
>> TO
>> UserNameGoesHere
>> --
>> Keith
>>
>> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
>> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
>> > Hi ,
>> >
>> > I have created a login id on 2 different databases DB_A & DB_B as the
>> > owner
>> >
>> > from crystal report i can see the view of DB_A but not DB_B using the
>> > same
>> > login id
>> >
>> > Could anyone kindly advise ?
>> >
>> > tks & rdgs
>>|||no worries Keith , tks for all the help given
Cheers,
maxzsim
"Keith Kratochvil" wrote:
> Does Crystal "know" that the other view exists within the other database?
> Can you tell it to look in the other database for the view? Sorry, I have
> not used Crystal since version 5.
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
> > Hi Keith ,
> >
> > the default db for the login is master. and i have set up 2 odbc
> > datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> > from crystal when connecting using DS_A it can show me the view but not
> > when
> > using DS_B
> >
> > i hope this time i am clearer in my explanation
> >
> > i'll try to use the grant select on the view for that login in DB_B
> >
> > tks & rdgs
> > "Keith Kratochvil" wrote:
> >
> >> Your post is not clear.
> >>
> >> What is the default database for the login? Is Crystal connecting to
> >> DB_A?
> >> If so it will be able to see the view in that database. Unless you
> >> "tell"
> >> Crystal to look within DB_B for the view it will not be found.
> >>
> >> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere
> >> TO
> >> UserNameGoesHere
> >>
> >> --
> >> Keith
> >>
> >>
> >> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> >> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> >> > Hi ,
> >> >
> >> > I have created a login id on 2 different databases DB_A & DB_B as the
> >> > owner
> >> >
> >> > from crystal report i can see the view of DB_A but not DB_B using the
> >> > same
> >> > login id
> >> >
> >> > Could anyone kindly advise ?
> >> >
> >> > tks & rdgs
> >>
> >>
> >>
>
>

Cannot see the cube using Crystal Analysis 9

Hi,

I'm currently using SQL 2000 Analysis Manager to create a cube, and Crystal Analysis 9 to try to view the cube.

When I grant the role of the cube to "Everyone", there is no problem, CA is able to view the cube.

However, when the role is granted to a specific "domain account", the cube is NOT showing up in CA...

My settings are: SQL 2000 on one PC, and CA on another PC. Both are under the same domain, and both are logged in using the same domain account. Also, this domain account is already granted the "Administrator" rights in SQL 2000 PC.

Any idea why this is happening?

Anyone ran into this problem too?

Thanks very much in advance.

sendmehere.

Try to narrow problem a little bit.

Try and use another application to browse your AS2000 cubes. You can try Excel PivotTables for that. See if you can connect and see the cubes.

If Excel works for you, the problem is then with CA.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward, I'll try that on Monday!!!

Will let you know the result afterwards.

|||

bad news...

When I use EXCEL pivot table, it is able to connect to the cube with or without a proper domain account / password...

so I cannot proof that it is CA problem...

Or it may be the Analysis Manager's problem?

Anymore ideas?

Thanks!!!

|||

If Excel is able to connect, the problem is likely in the CA.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.