OWC and SSAS2005 Perspectives

#1

I want to work with Analysis Services 2005 and OWC11 in my own application
like Business Intelligence Development Studio.
But I don't know, how to work with perspectives in OWC. Can I use an
connection string property e.g.
Provider=MSOLAP.3; Initial Catalo= Adventure Works DW;CommandText=Adventure
Works;....;Perspectives=???

Many thanks for a solution.

Reinfried

#2

Perspectives should just appear like any other cube, so you should be able to
substitute a perspective name wherever you would use a cube name. Note - I've
not actually tested to see whether this works in OWC, but that's the theory...

Chris
--
Blog at:
http://spaces.msn.com/members/cwebbbi/

"Reinfried" wrote:

Quote:

I want to work with Analysis Services 2005 and OWC11 in my own application
like Business Intelligence Development Studio.
But I don't know, how to work with perspectives in OWC. Can I use an
connection string property e.g.
Provider=MSOLAP.3; Initial Catalo= Adventure Works DW;CommandText=Adventure
Works;....;Perspectives=???

Many thanks for a solution.

Reinfried

#3

I've done it and Chris' description is exactly right.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Chris Webb" <OnlyForPostingToNewsgroups (AT) hotmail (DOT) com> wrote

Quote:

Perspectives should just appear like any other cube, so you should be able
to
substitute a perspective name wherever you would use a cube name. Note -
I've
not actually tested to see whether this works in OWC, but that's the
theory...

Chris
--
Blog at:
http://spaces.msn.com/members/cwebbbi/

"Reinfried" wrote:

I want to work with Analysis Services 2005 and OWC11 in my own
application
like Business Intelligence Development Studio.
But I don't know, how to work with perspectives in OWC. Can I use an
connection string property e.g.
Provider=MSOLAP.3; Initial Catalo= Adventure Works
DW;CommandText=Adventure
Works;....;Perspectives=???

Many thanks for a solution.

Reinfried

#4

Many thanks for the tip. I have test it with Excel PivotTabel, OWC10, OWC11
and Excel Add-in for SQL Server Analysis Services.

Only the Excel Add-in for SQL Server Analysis Services works correct with
Dimensions and Measure Groups.

Excel PivotTabel, OWC10 and OWC11 don't shows Dimensions and Measures Group
correct.

e.g. Perspective Finance in AdventureWorks DW:

Dimension Account: the PivotTable-FieldList shows the Dimension Account and
all Attributhierachies( Accounts, Account, Account Number and Account Type)
as Dimensions.

The perspective Finance have 6 Dimension but the PivotTable-FieldLists
(Excel and OWC) shows 24 Dimensions.

This is a great problem for end-users.

"Dave Wickert [MSFT]" wrote:

Quote:

I've done it and Chris' description is exactly right.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Chris Webb" <OnlyForPostingToNewsgroups (AT) hotmail (DOT) com> wrote in message
news:7CBE96D2-C709-4456-A3C1-7D9C53FA83CF (AT) microsoft (DOT) com...
Perspectives should just appear like any other cube, so you should be able
to
substitute a perspective name wherever you would use a cube name. Note -
I've
not actually tested to see whether this works in OWC, but that's the
theory...

Chris
--
Blog at:
http://spaces.msn.com/members/cwebbbi/

"Reinfried" wrote:

I want to work with Analysis Services 2005 and OWC11 in my own
application
like Business Intelligence Development Studio.
But I don't know, how to work with perspectives in OWC. Can I use an
connection string property e.g.
Provider=MSOLAP.3; Initial Catalo= Adventure Works
DW;CommandText=Adventure
Works;....;Perspectives=???

Many thanks for a solution.

Reinfried

#5

Many thanks for the tip. I have test it with Excel PivotTabel, OWC10, OWC11
and Excel Add-in for SQL Server Analysis Services.

Only the Excel Add-in for SQL Server Analysis Services works correct with
Dimensions and Measure Groups.

Excel PivotTabel, OWC10 and OWC11 don't shows Dimensions and Measures Group
correct.

e.g. Perspective Finance in AdventureWorks DW:

Dimension Account: the PivotTable-FieldList shows the Dimension Account and
all Attributhierachies( Accounts, Account, Account Number and Account Type)
as Dimensions.

The perspective Finance have 6 Dimension but the PivotTable-FieldLists
(Excel and OWC) shows 24 Dimensions.

This is a great problem for end-users.

"Chris Webb" wrote:

Quote:

Perspectives should just appear like any other cube, so you should be able to
substitute a perspective name wherever you would use a cube name. Note - I've
not actually tested to see whether this works in OWC, but that's the theory...

Chris
--
Blog at:
http://spaces.msn.com/members/cwebbbi/

"Reinfried" wrote:

I want to work with Analysis Services 2005 and OWC11 in my own application
like Business Intelligence Development Studio.
But I don't know, how to work with perspectives in OWC. Can I use an
connection string property e.g.
Provider=MSOLAP.3; Initial Catalo= Adventure Works DW;CommandText=Adventure
Works;....;Perspectives=???

Many thanks for a solution.

Reinfried

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

OWC and SSAS2005 Perspectives

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

OWC and SSAS2005 Perspectives - 12-06-2005 , 06:17 AM

RE: OWC and SSAS2005 Perspectives - 12-06-2005 , 08:35 AM

Re: OWC and SSAS2005 Perspectives - 12-07-2005 , 06:13 PM

Re: OWC and SSAS2005 Perspectives - 12-12-2005 , 08:10 AM

RE: OWC and SSAS2005 Perspectives - 12-12-2005 , 08:16 AM