Product Dimensions

I have several items and the business views these items according to a number of attributes linked to the item:
- Product category
- Product source (manufactured, purchased, transferred)
- Brand
- Flavour
- Packing Group

The Packing Group is a combination of attributes which defines the size of a pack (bottle size, cap type, things like that). There is never a set hierarchy as to how these are viewed. I've thought about modelling items as:
1. Create a star-schema dimension which has Product category then Product, and have a bunch of attributes hanging off Product
2. Create virtual dimensions based on these attributes

However, this seems problematic to me as the Packing Group has its own attributes. I then consider I might need a "physical" star-schema dimension for each of the above classifications. Is this the right way to go? Can any body suggest a better way or point me to some examples? I'm running AS 2000.

Upgrade to 2005

The last time I did this in AS 2000, I was representing customer demographics - race, gender, age range, income range, etc), I created a physical dimension table in my star to represent each unique combination of attributes. then I created an AS dimension for each attribute. Performance was pretty poor.

ProClarity and Windows Vista

I have recently moved over to Windows Vista Business Edition and have issues
with the installation of ProClarity 6.1 (also with v6.3).
Having installed ProClarity, I find that it fails to launch. All I get is a
Windows message stating that it has stopped working.
Has anyone else had this issue and found a resolution?
Hello.
Did you mean ProClarity Desktop? There is hotfix for this :
http://www.microsoft.com/downloads/details.aspx?FamilyID=7a65e401-b298-46c6-a370-ce9d65d4fb21&DisplayLang=en
And checks. As I know, hotfix for ProClarity Analytics released as well.
+--
Kenial.GhostOnNetwork.
Darren wrote:
> I have recently moved over to Windows Vista Business Edition and have issues
> with the installation of ProClarity 6.1 (also with v6.3).
> Having installed ProClarity, I find that it fails to launch. All I get is a
> Windows message stating that it has stopped working.
> Has anyone else had this issue and found a resolution?
sql

ProClarity and Windows Vista

I have recently moved over to Windows Vista Business Edition and have issues
with the installation of ProClarity 6.1 (also with v6.3).
Having installed ProClarity, I find that it fails to launch. All I get is a
Windows message stating that it has stopped working.
Has anyone else had this issue and found a resolution?Hello.
Did you mean ProClarity Desktop? There is hotfix for this :
http://www.microsoft.com/downloads/...&DisplayLang=en
And checks. As I know, hotfix for ProClarity Analytics released as well.
+--
Kenial.GhostOnNetwork.
Darren wrote:
> I have recently moved over to Windows Vista Business Edition and have issu
es
> with the installation of ProClarity 6.1 (also with v6.3).
> Having installed ProClarity, I find that it fails to launch. All I get is
a
> Windows message stating that it has stopped working.
> Has anyone else had this issue and found a resolution?

process cube

I am using analysis server 2000. I have a cube on one of the databases which i am trying to process through the Business Intelligence Development studio.

i have specified the Server and the database name in the 'connection managers' through 'New Analysis Services Connection'

I added the 'Analysis Services Processing Task' to the Control flow but get the following error when i double click on it:

"A connection cannot be made. Ensure that the server is running'

Does anyone know what am i doing wrong?

Any help is appreciated.

Unfortunately you will not be able to use AS 2005 tools against AS2000.

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

|||

Edward,

Are you from Microsoft's SQL Server Team.

Just wanted to know if the answer was official :)

thanks