Showing posts with label ssas. Show all posts
Showing posts with label ssas. Show all posts

Thursday, March 29, 2012

ETL and SSIS/SSAS roles in it all.

I am a student in a data warehousing class. This is my only experience using
SQL Server 2005 BI ETL tools. I need to extract, transform, and load into a
data warehouse using SQL Server 2005. I've extracted all tables from my 3nf
d.b. into flat files using SSIS. My question is about the connection
between SSIS and SSAS, and how I create the time dimension (in SSAS?) and
then have it connect back to my process in SSIS so I can do the final load
into it.
I thought I could use SSIS for the entire ETL process. Now I'm discovering
I somehow need to bring in SSAS to define the dimensions and somehow finish
up in SSIS again.
I defined my source d.b. and final destination data warehouse in regular SQL
Server tables. Do I need to delete the final destination data warehouse
database and redefine it as dimensions in SSAS?
Any help on this is appreciated. If you even have a recommended tutorial
that would help as well.
Hello Laura,
there are a number of ways to skin this cat.
The way I usually do it is
Build a relational DB (Star Schema)
Build an SSAS Cube over the top of that schema.
Use SSIS to load up the relation DB
In 2K5 you also though can load the SSAS partitions and dimensions directly
through SSIS which is way cool.

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

> I am a student in a data warehousing class. This is my only experience
> using SQL Server 2005 BI ETL tools. I need to extract, transform, and
> load into a data warehouse using SQL Server 2005. I've extracted all
> tables from my 3nf d.b. into flat files using SSIS. My question is
> about the connection between SSIS and SSAS, and how I create the time
> dimension (in SSAS?) and then have it connect back to my process in
> SSIS so I can do the final load into it.
> I thought I could use SSIS for the entire ETL process. Now I'm
> discovering I somehow need to bring in SSAS to define the dimensions
> and somehow finish up in SSIS again.
> I defined my source d.b. and final destination data warehouse in
> regular SQL Server tables. Do I need to delete the final destination
> data warehouse database and redefine it as dimensions in SSAS?
> Any help on this is appreciated. If you even have a recommended
> tutorial that would help as well.
>
sql

ETL and SSIS/SSAS roles in it all.

I am a student in a data warehousing class. This is my only experience using
SQL Server 2005 BI ETL tools. I need to extract, transform, and load into a
data warehouse using SQL Server 2005. I've extracted all tables from my 3nf
d.b. into flat files using SSIS. My question is about the connection
between SSIS and SSAS, and how I create the time dimension (in SSAS?) and
then have it connect back to my process in SSIS so I can do the final load
into it.
I thought I could use SSIS for the entire ETL process. Now I'm discovering
I somehow need to bring in SSAS to define the dimensions and somehow finish
up in SSIS again.
I defined my source d.b. and final destination data warehouse in regular SQL
Server tables. Do I need to delete the final destination data warehouse
database and redefine it as dimensions in SSAS?
Any help on this is appreciated. If you even have a recommended tutorial
that would help as well.Hello Laura,
there are a number of ways to skin this cat.
The way I usually do it is
Build a relational DB (Star Schema)
Build an SSAS Cube over the top of that schema.
Use SSIS to load up the relation DB
In 2K5 you also though can load the SSAS partitions and dimensions directly
through SSIS which is way cool.
Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

> I am a student in a data warehousing class. This is my only experience
> using SQL Server 2005 BI ETL tools. I need to extract, transform, and
> load into a data warehouse using SQL Server 2005. I've extracted all
> tables from my 3nf d.b. into flat files using SSIS. My question is
> about the connection between SSIS and SSAS, and how I create the time
> dimension (in SSAS?) and then have it connect back to my process in
> SSIS so I can do the final load into it.
> I thought I could use SSIS for the entire ETL process. Now I'm
> discovering I somehow need to bring in SSAS to define the dimensions
> and somehow finish up in SSIS again.
> I defined my source d.b. and final destination data warehouse in
> regular SQL Server tables. Do I need to delete the final destination
> data warehouse database and redefine it as dimensions in SSAS?
> Any help on this is appreciated. If you even have a recommended
> tutorial that would help as well.
>

Wednesday, March 21, 2012

Errors using report designer with ssas based report model

I have created a report model based on an SSAS database. It is usable without
errors with Report Builder as far as I can tell. However with Report
Designer, the layout displays the cube elements but errors on preview as
follows:
"The 'PerspectiveId' custom property for the 'query' perspective is either
not set or is not set to the string data type."
This is an error that has cropped up before but I'm not aware of a bug
report for it. The forum and blog guidance I have for fixing it is to:
- Create a report builder report and save it to file
- Copy the customproperties xml subtree and paste it into the Report
Designer report
I have done this but unfortunately this also errors on reopening the report
as follows:
"A connection cannot be made to the database. Set and test the connection
string. Additional information: TODO - change code to use RsProxy object
(Microsoft.ReportingServices.QueryDesigners)"
Notwithstanding the slightly disconcerting TODO comment lingering in the
code, can anyone advise cause and resolution/workaround?
Thanks in advance
David
using:
- SQL Server 2005 Analysis Services 9.0.3042
- Windows XP Pro SP2
- Visual Studio 2005 SP1
-- report designer rdl follows
--
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="dataSource1">
<DataSourceReference>dataSource1</DataSourceReference>
<rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>2.5cm</BottomMargin>
<RightMargin>2.5cm</RightMargin>
<PageWidth>21cm</PageWidth>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>21cm</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<Height>5cm</Height>
</Body>
<rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
<LeftMargin>2.5cm</LeftMargin>
<DataSets>
<DataSet Name="DataSet1">
<Query>
<CommandText><SemanticQuery
xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
xmlns:rb="http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
<Hierarchies>
<Hierarchy>
<BaseEntity>
<!--DimGeneric-->
<EntityID
xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
</BaseEntity>
<Groupings>
<Grouping Name="Generic Description">
<Expression Name="Generic Description">
<AttributeRef>
<!--Generic Description-->
<AttributeID
xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
</AttributeRef>
</Expression>
</Grouping>
</Groupings>
</Hierarchy>
</Hierarchies>
--start of report builder sourced subtree
<CustomProperties>
<CustomProperty Name="qd:PerspectiveID">
<Value
xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
</CustomProperty>
</CustomProperties>
--end of report builder sourced subtree
</SemanticQuery></CommandText>
<DataSourceName>dataSource1</DataSourceName>
</Query>
<Fields>
<Field Name="Generic_Description">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Generic Description</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>16cm</Width>
<InteractiveHeight>29.7cm</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>I have also noticed that if I open a Report Builder report in Report Designer
and change the data source guid to match the data source in the report server
project, the preview displays the expected results and the generic query
designer view also works as expected, but the "query could not be loaded"
message still appears when attempting to use the data tab without the query
designer.
"David Norman" wrote:
> I have created a report model based on an SSAS database. It is usable without
> errors with Report Builder as far as I can tell. However with Report
> Designer, the layout displays the cube elements but errors on preview as
> follows:
> "The 'PerspectiveId' custom property for the 'query' perspective is either
> not set or is not set to the string data type."
> This is an error that has cropped up before but I'm not aware of a bug
> report for it. The forum and blog guidance I have for fixing it is to:
> - Create a report builder report and save it to file
> - Copy the customproperties xml subtree and paste it into the Report
> Designer report
> I have done this but unfortunately this also errors on reopening the report
> as follows:
> "A connection cannot be made to the database. Set and test the connection
> string. Additional information: TODO - change code to use RsProxy object
> (Microsoft.ReportingServices.QueryDesigners)"
> Notwithstanding the slightly disconcerting TODO comment lingering in the
> code, can anyone advise cause and resolution/workaround?
> Thanks in advance
> David
> using:
> - SQL Server 2005 Analysis Services 9.0.3042
> - Windows XP Pro SP2
> - Visual Studio 2005 SP1
> -- report designer rdl follows
> --
> <?xml version="1.0" encoding="utf-8"?>
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <DataSources>
> <DataSource Name="dataSource1">
> <DataSourceReference>dataSource1</DataSourceReference>
> <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> </DataSource>
> </DataSources>
> <BottomMargin>2.5cm</BottomMargin>
> <RightMargin>2.5cm</RightMargin>
> <PageWidth>21cm</PageWidth>
> <rd:DrawGrid>true</rd:DrawGrid>
> <InteractiveWidth>21cm</InteractiveWidth>
> <rd:GridSpacing>0.25cm</rd:GridSpacing>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <Body>
> <ColumnSpacing>1cm</ColumnSpacing>
> <Height>5cm</Height>
> </Body>
> <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> <LeftMargin>2.5cm</LeftMargin>
> <DataSets>
> <DataSet Name="DataSet1">
> <Query>
> <CommandText><SemanticQuery
> xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> <Hierarchies>
> <Hierarchy>
> <BaseEntity>
> <!--DimGeneric-->
> <EntityID
> xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> </BaseEntity>
> <Groupings>
> <Grouping Name="Generic Description">
> <Expression Name="Generic Description">
> <AttributeRef>
> <!--Generic Description-->
> <AttributeID
> xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> </AttributeRef>
> </Expression>
> </Grouping>
> </Groupings>
> </Hierarchy>
> </Hierarchies>
> --start of report builder sourced subtree
> <CustomProperties>
> <CustomProperty Name="qd:PerspectiveID">
> <Value
> xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> </CustomProperty>
> </CustomProperties>
> --end of report builder sourced subtree
> </SemanticQuery></CommandText>
> <DataSourceName>dataSource1</DataSourceName>
> </Query>
> <Fields>
> <Field Name="Generic_Description">
> <rd:TypeName>System.String</rd:TypeName>
> <DataField>Generic Description</DataField>
> </Field>
> </Fields>
> </DataSet>
> </DataSets>
> <Width>16cm</Width>
> <InteractiveHeight>29.7cm</InteractiveHeight>
> <Language>en-US</Language>
> <TopMargin>2.5cm</TopMargin>
> <PageHeight>29.7cm</PageHeight>
> </Report>|||It appears this error does not occur for the same report model on a PC which
doesn't have VS2005 SP1 installed!
"David Norman" wrote:
> I have also noticed that if I open a Report Builder report in Report Designer
> and change the data source guid to match the data source in the report server
> project, the preview displays the expected results and the generic query
> designer view also works as expected, but the "query could not be loaded"
> message still appears when attempting to use the data tab without the query
> designer.
> "David Norman" wrote:
> > I have created a report model based on an SSAS database. It is usable without
> > errors with Report Builder as far as I can tell. However with Report
> > Designer, the layout displays the cube elements but errors on preview as
> > follows:
> >
> > "The 'PerspectiveId' custom property for the 'query' perspective is either
> > not set or is not set to the string data type."
> >
> > This is an error that has cropped up before but I'm not aware of a bug
> > report for it. The forum and blog guidance I have for fixing it is to:
> >
> > - Create a report builder report and save it to file
> > - Copy the customproperties xml subtree and paste it into the Report
> > Designer report
> >
> > I have done this but unfortunately this also errors on reopening the report
> > as follows:
> >
> > "A connection cannot be made to the database. Set and test the connection
> > string. Additional information: TODO - change code to use RsProxy object
> > (Microsoft.ReportingServices.QueryDesigners)"
> >
> > Notwithstanding the slightly disconcerting TODO comment lingering in the
> > code, can anyone advise cause and resolution/workaround?
> >
> > Thanks in advance
> > David
> >
> > using:
> > - SQL Server 2005 Analysis Services 9.0.3042
> > - Windows XP Pro SP2
> > - Visual Studio 2005 SP1
> >
> > -- report designer rdl follows
> > --
> >
> > <?xml version="1.0" encoding="utf-8"?>
> > <Report
> > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> > <DataSources>
> > <DataSource Name="dataSource1">
> > <DataSourceReference>dataSource1</DataSourceReference>
> > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> > </DataSource>
> > </DataSources>
> > <BottomMargin>2.5cm</BottomMargin>
> > <RightMargin>2.5cm</RightMargin>
> > <PageWidth>21cm</PageWidth>
> > <rd:DrawGrid>true</rd:DrawGrid>
> > <InteractiveWidth>21cm</InteractiveWidth>
> > <rd:GridSpacing>0.25cm</rd:GridSpacing>
> > <rd:SnapToGrid>true</rd:SnapToGrid>
> > <Body>
> > <ColumnSpacing>1cm</ColumnSpacing>
> > <Height>5cm</Height>
> > </Body>
> > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> > <LeftMargin>2.5cm</LeftMargin>
> > <DataSets>
> > <DataSet Name="DataSet1">
> > <Query>
> > <CommandText><SemanticQuery
> > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> > <Hierarchies>
> > <Hierarchy>
> > <BaseEntity>
> > <!--DimGeneric-->
> > <EntityID
> > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> > </BaseEntity>
> > <Groupings>
> > <Grouping Name="Generic Description">
> > <Expression Name="Generic Description">
> > <AttributeRef>
> > <!--Generic Description-->
> > <AttributeID
> > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> > </AttributeRef>
> > </Expression>
> > </Grouping>
> > </Groupings>
> > </Hierarchy>
> > </Hierarchies>
> >
> > --start of report builder sourced subtree
> >
> > <CustomProperties>
> > <CustomProperty Name="qd:PerspectiveID">
> > <Value
> > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> > </CustomProperty>
> > </CustomProperties>
> >
> > --end of report builder sourced subtree
> >
> > </SemanticQuery></CommandText>
> > <DataSourceName>dataSource1</DataSourceName>
> > </Query>
> > <Fields>
> > <Field Name="Generic_Description">
> > <rd:TypeName>System.String</rd:TypeName>
> > <DataField>Generic Description</DataField>
> > </Field>
> > </Fields>
> > </DataSet>
> > </DataSets>
> > <Width>16cm</Width>
> > <InteractiveHeight>29.7cm</InteractiveHeight>
> > <Language>en-US</Language>
> > <TopMargin>2.5cm</TopMargin>
> > <PageHeight>29.7cm</PageHeight>
> > </Report>|||I finally found a bug report on Connect for SQL Server 2005 SP2 (Client Tools)
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260746
Microsoft will "consider fixing it in a future release". There is no
workaround listed, and I have found nothing better than selectively removing
and adding the customproperties subtree to enable different parts of the
report designer (which of course is a big nuisance).
BTW thanks world for not replying to my posts!
"David Norman" wrote:
> It appears this error does not occur for the same report model on a PC which
> doesn't have VS2005 SP1 installed!
> "David Norman" wrote:
> > I have also noticed that if I open a Report Builder report in Report Designer
> > and change the data source guid to match the data source in the report server
> > project, the preview displays the expected results and the generic query
> > designer view also works as expected, but the "query could not be loaded"
> > message still appears when attempting to use the data tab without the query
> > designer.
> >
> > "David Norman" wrote:
> >
> > > I have created a report model based on an SSAS database. It is usable without
> > > errors with Report Builder as far as I can tell. However with Report
> > > Designer, the layout displays the cube elements but errors on preview as
> > > follows:
> > >
> > > "The 'PerspectiveId' custom property for the 'query' perspective is either
> > > not set or is not set to the string data type."
> > >
> > > This is an error that has cropped up before but I'm not aware of a bug
> > > report for it. The forum and blog guidance I have for fixing it is to:
> > >
> > > - Create a report builder report and save it to file
> > > - Copy the customproperties xml subtree and paste it into the Report
> > > Designer report
> > >
> > > I have done this but unfortunately this also errors on reopening the report
> > > as follows:
> > >
> > > "A connection cannot be made to the database. Set and test the connection
> > > string. Additional information: TODO - change code to use RsProxy object
> > > (Microsoft.ReportingServices.QueryDesigners)"
> > >
> > > Notwithstanding the slightly disconcerting TODO comment lingering in the
> > > code, can anyone advise cause and resolution/workaround?
> > >
> > > Thanks in advance
> > > David
> > >
> > > using:
> > > - SQL Server 2005 Analysis Services 9.0.3042
> > > - Windows XP Pro SP2
> > > - Visual Studio 2005 SP1
> > >
> > > -- report designer rdl follows
> > > --
> > >
> > > <?xml version="1.0" encoding="utf-8"?>
> > > <Report
> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> > > <DataSources>
> > > <DataSource Name="dataSource1">
> > > <DataSourceReference>dataSource1</DataSourceReference>
> > > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> > > </DataSource>
> > > </DataSources>
> > > <BottomMargin>2.5cm</BottomMargin>
> > > <RightMargin>2.5cm</RightMargin>
> > > <PageWidth>21cm</PageWidth>
> > > <rd:DrawGrid>true</rd:DrawGrid>
> > > <InteractiveWidth>21cm</InteractiveWidth>
> > > <rd:GridSpacing>0.25cm</rd:GridSpacing>
> > > <rd:SnapToGrid>true</rd:SnapToGrid>
> > > <Body>
> > > <ColumnSpacing>1cm</ColumnSpacing>
> > > <Height>5cm</Height>
> > > </Body>
> > > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> > > <LeftMargin>2.5cm</LeftMargin>
> > > <DataSets>
> > > <DataSet Name="DataSet1">
> > > <Query>
> > > <CommandText><SemanticQuery
> > > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> > > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> > > <Hierarchies>
> > > <Hierarchy>
> > > <BaseEntity>
> > > <!--DimGeneric-->
> > > <EntityID
> > > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> > > </BaseEntity>
> > > <Groupings>
> > > <Grouping Name="Generic Description">
> > > <Expression Name="Generic Description">
> > > <AttributeRef>
> > > <!--Generic Description-->
> > > <AttributeID
> > > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> > > </AttributeRef>
> > > </Expression>
> > > </Grouping>
> > > </Groupings>
> > > </Hierarchy>
> > > </Hierarchies>
> > >
> > > --start of report builder sourced subtree
> > >
> > > <CustomProperties>
> > > <CustomProperty Name="qd:PerspectiveID">
> > > <Value
> > > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> > > </CustomProperty>
> > > </CustomProperties>
> > >
> > > --end of report builder sourced subtree
> > >
> > > </SemanticQuery></CommandText>
> > > <DataSourceName>dataSource1</DataSourceName>
> > > </Query>
> > > <Fields>
> > > <Field Name="Generic_Description">
> > > <rd:TypeName>System.String</rd:TypeName>
> > > <DataField>Generic Description</DataField>
> > > </Field>
> > > </Fields>
> > > </DataSet>
> > > </DataSets>
> > > <Width>16cm</Width>
> > > <InteractiveHeight>29.7cm</InteractiveHeight>
> > > <Language>en-US</Language>
> > > <TopMargin>2.5cm</TopMargin>
> > > <PageHeight>29.7cm</PageHeight>
> > > </Report>|||This is peer supported. Plus, MS people do not tend to be here. Although if
you have MSDN subscription you can do a managed newsgroup where you register
an alias and they guarantee I believe an answer in two days.
The fact no one answered means that people doing this for no pay and just
because they want to help did not jump in because they did not know an
answer.
In the future if you do not get an answer here you might try the web forums.
Different people hang out there and also more MS people hang out there.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
Oh, by the way. I assume at some point you might want help in the future.
Being hostile is a great way to get someone to help.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Norman" <DavidNorman@.discussions.microsoft.com> wrote in message
news:EEE6DAE4-46BB-4D6F-9E98-790176EBC0F9@.microsoft.com...
>I finally found a bug report on Connect for SQL Server 2005 SP2 (Client
>Tools)
> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260746
> Microsoft will "consider fixing it in a future release". There is no
> workaround listed, and I have found nothing better than selectively
> removing
> and adding the customproperties subtree to enable different parts of the
> report designer (which of course is a big nuisance).
> BTW thanks world for not replying to my posts!
> "David Norman" wrote:
>> It appears this error does not occur for the same report model on a PC
>> which
>> doesn't have VS2005 SP1 installed!
>> "David Norman" wrote:
>> > I have also noticed that if I open a Report Builder report in Report
>> > Designer
>> > and change the data source guid to match the data source in the report
>> > server
>> > project, the preview displays the expected results and the generic
>> > query
>> > designer view also works as expected, but the "query could not be
>> > loaded"
>> > message still appears when attempting to use the data tab without the
>> > query
>> > designer.
>> >
>> > "David Norman" wrote:
>> >
>> > > I have created a report model based on an SSAS database. It is usable
>> > > without
>> > > errors with Report Builder as far as I can tell. However with Report
>> > > Designer, the layout displays the cube elements but errors on preview
>> > > as
>> > > follows:
>> > >
>> > > "The 'PerspectiveId' custom property for the 'query' perspective is
>> > > either
>> > > not set or is not set to the string data type."
>> > >
>> > > This is an error that has cropped up before but I'm not aware of a
>> > > bug
>> > > report for it. The forum and blog guidance I have for fixing it is
>> > > to:
>> > >
>> > > - Create a report builder report and save it to file
>> > > - Copy the customproperties xml subtree and paste it into the Report
>> > > Designer report
>> > >
>> > > I have done this but unfortunately this also errors on reopening the
>> > > report
>> > > as follows:
>> > >
>> > > "A connection cannot be made to the database. Set and test the
>> > > connection
>> > > string. Additional information: TODO - change code to use RsProxy
>> > > object
>> > > (Microsoft.ReportingServices.QueryDesigners)"
>> > >
>> > > Notwithstanding the slightly disconcerting TODO comment lingering in
>> > > the
>> > > code, can anyone advise cause and resolution/workaround?
>> > >
>> > > Thanks in advance
>> > > David
>> > >
>> > > using:
>> > > - SQL Server 2005 Analysis Services 9.0.3042
>> > > - Windows XP Pro SP2
>> > > - Visual Studio 2005 SP1
>> > >
>> > > -- report designer rdl follows
>> > > --
>> > >
>> > > <?xml version="1.0" encoding="utf-8"?>
>> > > <Report
>> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
>> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
>> > > <DataSources>
>> > > <DataSource Name="dataSource1">
>> > > <DataSourceReference>dataSource1</DataSourceReference>
>> > >
>> > > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
>> > > </DataSource>
>> > > </DataSources>
>> > > <BottomMargin>2.5cm</BottomMargin>
>> > > <RightMargin>2.5cm</RightMargin>
>> > > <PageWidth>21cm</PageWidth>
>> > > <rd:DrawGrid>true</rd:DrawGrid>
>> > > <InteractiveWidth>21cm</InteractiveWidth>
>> > > <rd:GridSpacing>0.25cm</rd:GridSpacing>
>> > > <rd:SnapToGrid>true</rd:SnapToGrid>
>> > > <Body>
>> > > <ColumnSpacing>1cm</ColumnSpacing>
>> > > <Height>5cm</Height>
>> > > </Body>
>> > > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
>> > > <LeftMargin>2.5cm</LeftMargin>
>> > > <DataSets>
>> > > <DataSet Name="DataSet1">
>> > > <Query>
>> > > <CommandText><SemanticQuery
>> > > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
>> > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
>> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> > > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
>> > > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
>> > > <Hierarchies>
>> > > <Hierarchy>
>> > > <BaseEntity>
>> > > <!--DimGeneric-->
>> > > <EntityID
>> > > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
>> > > </BaseEntity>
>> > > <Groupings>
>> > > <Grouping Name="Generic Description">
>> > > <Expression Name="Generic Description">
>> > > <AttributeRef>
>> > > <!--Generic Description-->
>> > > <AttributeID
>> > > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
>> > > </AttributeRef>
>> > > </Expression>
>> > > </Grouping>
>> > > </Groupings>
>> > > </Hierarchy>
>> > > </Hierarchies>
>> > >
>> > > --start of report builder sourced subtree
>> > >
>> > > <CustomProperties>
>> > > <CustomProperty Name="qd:PerspectiveID">
>> > > <Value
>> > > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
>> > > </CustomProperty>
>> > > </CustomProperties>
>> > >
>> > > --end of report builder sourced subtree
>> > >
>> > > </SemanticQuery></CommandText>
>> > > <DataSourceName>dataSource1</DataSourceName>
>> > > </Query>
>> > > <Fields>
>> > > <Field Name="Generic_Description">
>> > > <rd:TypeName>System.String</rd:TypeName>
>> > > <DataField>Generic Description</DataField>
>> > > </Field>
>> > > </Fields>
>> > > </DataSet>
>> > > </DataSets>
>> > > <Width>16cm</Width>
>> > > <InteractiveHeight>29.7cm</InteractiveHeight>
>> > > <Language>en-US</Language>
>> > > <TopMargin>2.5cm</TopMargin>
>> > > <PageHeight>29.7cm</PageHeight>
>> > > </Report>|||Didn't intend to be hostile, sorry it came across that way. Hope someone gets
some benefit from my investigations.
"Bruce L-C [MVP]" wrote:
> This is peer supported. Plus, MS people do not tend to be here. Although if
> you have MSDN subscription you can do a managed newsgroup where you register
> an alias and they guarantee I believe an answer in two days.
> The fact no one answered means that people doing this for no pay and just
> because they want to help did not jump in because they did not know an
> answer.
> In the future if you do not get an answer here you might try the web forums.
> Different people hang out there and also more MS people hang out there.
> http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
> Oh, by the way. I assume at some point you might want help in the future.
> Being hostile is a great way to get someone to help.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "David Norman" <DavidNorman@.discussions.microsoft.com> wrote in message
> news:EEE6DAE4-46BB-4D6F-9E98-790176EBC0F9@.microsoft.com...
> >I finally found a bug report on Connect for SQL Server 2005 SP2 (Client
> >Tools)
> >
> > http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260746
> >
> > Microsoft will "consider fixing it in a future release". There is no
> > workaround listed, and I have found nothing better than selectively
> > removing
> > and adding the customproperties subtree to enable different parts of the
> > report designer (which of course is a big nuisance).
> >
> > BTW thanks world for not replying to my posts!
> >
> > "David Norman" wrote:
> >
> >> It appears this error does not occur for the same report model on a PC
> >> which
> >> doesn't have VS2005 SP1 installed!
> >>
> >> "David Norman" wrote:
> >>
> >> > I have also noticed that if I open a Report Builder report in Report
> >> > Designer
> >> > and change the data source guid to match the data source in the report
> >> > server
> >> > project, the preview displays the expected results and the generic
> >> > query
> >> > designer view also works as expected, but the "query could not be
> >> > loaded"
> >> > message still appears when attempting to use the data tab without the
> >> > query
> >> > designer.
> >> >
> >> > "David Norman" wrote:
> >> >
> >> > > I have created a report model based on an SSAS database. It is usable
> >> > > without
> >> > > errors with Report Builder as far as I can tell. However with Report
> >> > > Designer, the layout displays the cube elements but errors on preview
> >> > > as
> >> > > follows:
> >> > >
> >> > > "The 'PerspectiveId' custom property for the 'query' perspective is
> >> > > either
> >> > > not set or is not set to the string data type."
> >> > >
> >> > > This is an error that has cropped up before but I'm not aware of a
> >> > > bug
> >> > > report for it. The forum and blog guidance I have for fixing it is
> >> > > to:
> >> > >
> >> > > - Create a report builder report and save it to file
> >> > > - Copy the customproperties xml subtree and paste it into the Report
> >> > > Designer report
> >> > >
> >> > > I have done this but unfortunately this also errors on reopening the
> >> > > report
> >> > > as follows:
> >> > >
> >> > > "A connection cannot be made to the database. Set and test the
> >> > > connection
> >> > > string. Additional information: TODO - change code to use RsProxy
> >> > > object
> >> > > (Microsoft.ReportingServices.QueryDesigners)"
> >> > >
> >> > > Notwithstanding the slightly disconcerting TODO comment lingering in
> >> > > the
> >> > > code, can anyone advise cause and resolution/workaround?
> >> > >
> >> > > Thanks in advance
> >> > > David
> >> > >
> >> > > using:
> >> > > - SQL Server 2005 Analysis Services 9.0.3042
> >> > > - Windows XP Pro SP2
> >> > > - Visual Studio 2005 SP1
> >> > >
> >> > > -- report designer rdl follows
> >> > > --
> >> > >
> >> > > <?xml version="1.0" encoding="utf-8"?>
> >> > > <Report
> >> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> >> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> >> > > <DataSources>
> >> > > <DataSource Name="dataSource1">
> >> > > <DataSourceReference>dataSource1</DataSourceReference>
> >> > >
> >> > > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> >> > > </DataSource>
> >> > > </DataSources>
> >> > > <BottomMargin>2.5cm</BottomMargin>
> >> > > <RightMargin>2.5cm</RightMargin>
> >> > > <PageWidth>21cm</PageWidth>
> >> > > <rd:DrawGrid>true</rd:DrawGrid>
> >> > > <InteractiveWidth>21cm</InteractiveWidth>
> >> > > <rd:GridSpacing>0.25cm</rd:GridSpacing>
> >> > > <rd:SnapToGrid>true</rd:SnapToGrid>
> >> > > <Body>
> >> > > <ColumnSpacing>1cm</ColumnSpacing>
> >> > > <Height>5cm</Height>
> >> > > </Body>
> >> > > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> >> > > <LeftMargin>2.5cm</LeftMargin>
> >> > > <DataSets>
> >> > > <DataSet Name="DataSet1">
> >> > > <Query>
> >> > > <CommandText><SemanticQuery
> >> > > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> >> > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> >> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> >> > > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> >> > > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> >> > > <Hierarchies>
> >> > > <Hierarchy>
> >> > > <BaseEntity>
> >> > > <!--DimGeneric-->
> >> > > <EntityID
> >> > > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> >> > > </BaseEntity>
> >> > > <Groupings>
> >> > > <Grouping Name="Generic Description">
> >> > > <Expression Name="Generic Description">
> >> > > <AttributeRef>
> >> > > <!--Generic Description-->
> >> > > <AttributeID
> >> > > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> >> > > </AttributeRef>
> >> > > </Expression>
> >> > > </Grouping>
> >> > > </Groupings>
> >> > > </Hierarchy>
> >> > > </Hierarchies>
> >> > >
> >> > > --start of report builder sourced subtree
> >> > >
> >> > > <CustomProperties>
> >> > > <CustomProperty Name="qd:PerspectiveID">
> >> > > <Value
> >> > > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> >> > > </CustomProperty>
> >> > > </CustomProperties>
> >> > >
> >> > > --end of report builder sourced subtree
> >> > >
> >> > > </SemanticQuery></CommandText>
> >> > > <DataSourceName>dataSource1</DataSourceName>
> >> > > </Query>
> >> > > <Fields>
> >> > > <Field Name="Generic_Description">
> >> > > <rd:TypeName>System.String</rd:TypeName>
> >> > > <DataField>Generic Description</DataField>
> >> > > </Field>
> >> > > </Fields>
> >> > > </DataSet>
> >> > > </DataSets>
> >> > > <Width>16cm</Width>
> >> > > <InteractiveHeight>29.7cm</InteractiveHeight>
> >> > > <Language>en-US</Language>
> >> > > <TopMargin>2.5cm</TopMargin>
> >> > > <PageHeight>29.7cm</PageHeight>
> >> > > </Report>
>
>sql

Monday, March 19, 2012

Errors processing SSAS 2005 Cube against SQL 2000 database

Hi,

I am receiving the following erros when i try to deploy/process my cube. The source db is Sql Server 2000, could this be the issue? I have a connection created (have tried both OLDB providers - SQL Native client and MS OLDB provider) and I am supplying a sql server user name and pass word (datareader permission in db). The 2005 SSAS service is running under a local user account so authentication is not possible using that account. And I have tried various settings under "Impersonation Information" with no luck?

SQL 2K5 sp1 on Win XP sp2

Sql 2k (sp4) on Win2k server

Thanks!

Build started: Project: Aegis, Configuration: Development

Started Building Analysis Services project: Incremental ....

Build complete -- 0 errors, 0 warnings

Deploy started: Project: Aegis, Configuration: Development

Performing a full deployment of the 'Aegis' database to the 'JWILAMETZ\SQLSERVER2005_01' server.

Generating deployment script...

Add Database Aegis

Process Database Aegis

Done

Sending deployment script to the server...

Error -1056899072 : The following system error occurred: Logon failure: unknown user name or bad password. .

Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'IBANK AEGIS PROD DM', Name of 'IBANK AEGIS PROD DM'.

Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CURRENCY DIM', Name of 'CURRENCY DIM' was being processed.

Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'CURRENCY CD' attribute of the 'CURRENCY DIM' dimension from the 'Aegis' database was being processed.

Error -1056899072 : The following system error occurred: Logon failure: unknown user name or bad password. .

Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'IBANK AEGIS PROD DM', Name of 'IBANK AEGIS PROD DM'.

Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CURRENCY DIM', Name of 'CURRENCY DIM' was being processed.

Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'CURRENCY DESC' attribute of the 'CURRENCY DIM' dimension from the 'Aegis' database was being processed.

Error -1056899072 : The following system error occurred: Logon failure: unknown user name or bad password. .

Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'IBANK AEGIS PROD DM', Name of 'IBANK AEGIS PROD DM'.

Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CURRENCY DIM', Name of 'CURRENCY DIM' was being processed.

Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'DATE ENTERED' attribute of the 'CURRENCY DIM' dimension from the 'Aegis' database was being processed.

Error -1056899072 : The following system error occurred: Logon failure: unknown user name or bad password. .

Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'IBANK AEGIS PROD DM', Name of 'IBANK AEGIS PROD DM'.

Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CURRENCY DIM', Name of 'CURRENCY DIM' was being processed.

Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'EXCHANGE RATE' attribute of the 'CURRENCY DIM' dimension from the 'Aegis' database was being processed.

Deploy complete -- 16 errors, 0 warnings

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

First try and see if you connect to your SQL Server 2000 from AS machine.

Login into AS machine under credentials of your local user account and try connecting to your SQL Server machine.

The credentals many customers choosing for their Data Source object is ImpersonateServiceAccount.

Please note. Once you saved user name and password as part of your connection sting, you will have to re-submit username and password every time you update your datasource.

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

|||

Willajo,

can you please let me know how could you solve? I am getting the same error.

thanks a lot in advance...

Errors processing SSAS 2005 Cube against SQL 2000 database

Hi,

I am receiving the following erros when i try to deploy/process my cube. The source db is Sql Server 2000, could this be the issue? I have a connection created (have tried both OLDB providers - SQL Native client and MS OLDB provider) and I am supplying a sql server user name and pass word (datareader permission in db). The 2005 SSAS service is running under a local user account so authentication is not possible using that account. And I have tried various settings under "Impersonation Information" with no luck?

SQL 2K5 sp1 on Win XP sp2

Sql 2k (sp4) on Win2k server

Thanks!

Build started: Project: Aegis, Configuration: Development

Started Building Analysis Services project: Incremental ....

Build complete -- 0 errors, 0 warnings

Deploy started: Project: Aegis, Configuration: Development

Performing a full deployment of the 'Aegis' database to the 'JWILAMETZ\SQLSERVER2005_01' server.

Generating deployment script...

Add Database Aegis

Process Database Aegis

Done

Sending deployment script to the server...

Error -1056899072 : The following system error occurred: Logon failure: unknown user name or bad password. .

Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'IBANK AEGIS PROD DM', Name of 'IBANK AEGIS PROD DM'.

Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CURRENCY DIM', Name of 'CURRENCY DIM' was being processed.

Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'CURRENCY CD' attribute of the 'CURRENCY DIM' dimension from the 'Aegis' database was being processed.

Error -1056899072 : The following system error occurred: Logon failure: unknown user name or bad password. .

Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'IBANK AEGIS PROD DM', Name of 'IBANK AEGIS PROD DM'.

Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CURRENCY DIM', Name of 'CURRENCY DIM' was being processed.

Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'CURRENCY DESC' attribute of the 'CURRENCY DIM' dimension from the 'Aegis' database was being processed.

Error -1056899072 : The following system error occurred: Logon failure: unknown user name or bad password. .

Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'IBANK AEGIS PROD DM', Name of 'IBANK AEGIS PROD DM'.

Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CURRENCY DIM', Name of 'CURRENCY DIM' was being processed.

Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'DATE ENTERED' attribute of the 'CURRENCY DIM' dimension from the 'Aegis' database was being processed.

Error -1056899072 : The following system error occurred: Logon failure: unknown user name or bad password. .

Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'IBANK AEGIS PROD DM', Name of 'IBANK AEGIS PROD DM'.

Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'CURRENCY DIM', Name of 'CURRENCY DIM' was being processed.

Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'EXCHANGE RATE' attribute of the 'CURRENCY DIM' dimension from the 'Aegis' database was being processed.

Deploy complete -- 16 errors, 0 warnings

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

First try and see if you connect to your SQL Server 2000 from AS machine.

Login into AS machine under credentials of your local user account and try connecting to your SQL Server machine.

The credentals many customers choosing for their Data Source object is ImpersonateServiceAccount.

Please note. Once you saved user name and password as part of your connection sting, you will have to re-submit username and password every time you update your datasource.

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

|||

Willajo,

can you please let me know how could you solve? I am getting the same error.

thanks a lot in advance...

Errors processing SSAS 2005

Hi,

I am receiving the following error when i try to deploy project.

Error 1 The following system error occurred: .

AS 2005 SP1

Windows Server 2003 Ent. SP1


Make sure Analysis Server is runing. Go to the project's properties and make sure your project points to the Analysis Server.

Can you also describe the error. Is it a single error. Are there more errors? Is this the first time you are trying to deploy?

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

|||

Hello Edward!

On your questions: Analysis Server is runing - Yes, project points to the Analysis Server - Yes

Is it a single error - Yes. Is this the first time you are trying to deploy? - No, The error has appeared after the server became DC.

New projects are developed normally, All cubes old and new process is normal.

|||

This could be very much as a result of your computer becoming domaing controller.

Can you connect to Anlaysis Server from SQL Management Studio?

Try deleting everything from the data folder and restarting Analysis Server. This cause you to loose all of your databases, make sure you have you projects saved so you can re-create databases again .

If that doesnt help, the only solution I see is to try and re-install Analysis Services.

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