Hi,
i was building a dimension for product using Adventure Works DW
database.

Steps i followed are
1. Dim product as main table for the Product table for the standard
dimension.
2. Selected productkey as the main key

3. Selected DimProductCategory, DimProductSubCategory the related
tables.

4. Selected Attributes

a. English product Category name
b. English Product Sub Category name
c. English product name
d. Color
e. Style
f. Weight

5. Selected dimension type as regular

6. No parent child relation ship specified as it is standard
dimension

7. Next Pane Dimension contains no hierarchies

8. Named the dimension as Product, Click finish

9. Created product hierarchy containing
a. product Category (renamed from "English
product"Category name)
b. Product SubCategroy (rename from English Product Sub
Category name)
c. Product name (renamed from English product name)

10. process the dimension

11. It is giving me series of errors
a. The following system error occurred: No mapping between
account names and security IDs was done.

( I COULD NOT really understand what it is speaking of)

b. Errors in the high-level relational engine. A connection
could not be made to the data source with the DataSourceID
of 'Adventure Works DW', Name of ''.

( I HAVE CREATED DATASOURCE 'Adventure Works DW' allready)

c. Errors in the OLAP storage engine: An error occurred while
the dimension, with the ID of 'Dim Product', Name of 'Dim
Product' was being processed.

d. Errors in the OLAP storage engine: An error occurred while
the 'English Product Name' attribute of the 'Dim Product'
dimension from the 'Analysis Services Project2' database
was being processed.
e. Errors in the OLAP storage engine: An error occurred while
the 'Color' attribute of the 'Dim Product' dimension from
the 'Analysis Services Project2' database was being
processed.
f. Errors in the OLAP storage engine: An error occurred while
the 'Weight' attribute of the 'Dim Product' dimension from
the 'Analysis Services Project2' database was being
processed.

i could not understand what are all these errors

Can any one explain what is the simple mistake which has happened

Regards,
Prasanna

I think the errors all cascade from the first one (the part about
account names and security IDs). I've seen this when I've given
someone a SSAS project that has users or groups listed in a role object
that are not available to the person trying to deploy the project.

The SSAS cannot resolve a name in the role to a security ID. Try
opening any role objects and making sure that users or groups are
listed that can be resolved by the server.

Please clarify in very simpler steps what should i do. I highly
appreciate your earliest response

Regards,
Prasanna

Let me clarify i haven't created any roles in the Analysis services
project

The simple answer for this. Right click the data source Open and in the
Impersonation information select the radio button " use the service
account". this might be beacuse the Olapservice runs under Local
System account

Regards,
Prasanna