Re: How to create new Dimension members?

Hi Clint,

Thanks for your reply. I think that using the Dimension Editor will create
a new Dimension. My problem is how to create a new Member (dimension
member) in an existing dimension. The reason I ask is because the tutorial
states that you have to have Sql Server Enterprise in order to add members to
an existing dimension from within the editor. Unfortunately, I only have
standard edition which does not have this feature.

Is there a way to create new members to an existing dimension? Where do the
other members come from? Are they built-in members when you create a
particular dimension or are these members based on columns in the dimention
table?

like what is the origin of these members? All I did was to follow the steps
in the Dimension wizard, selected the Account measure, and then the wizard
did the rest. But the tutorial had a step where you add a member (sub
member) to the "Total Expenses" member. Is there a way to add a member
without using the wizard?

All Aco***
--- ~Assets
--- ~Liabilities
--- +Net Income
------ -(Net Income Data)
------ +Net Sales
------ -Cost of Goods Sold
------ +Gross Sales
------ +(Net Sales Data)
------ -Total Expenses
--------- +General & Administration
--------- +Information Systems
--------- +Lease
--------- +Marketing
--------- +(Total Expense Data)

Thanks,
Rich

"Clint" wrote:

> If creating a shared dimension...
> Right Click on Shared Dimensions > New > Editor
>
> If creating a private dimension...
> Edit the cube > Right Click on Dimensions > New > Editor
> "Rich" <Rich@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:8D223F41-CFC6-4CB7-B1E9-F6DE3521EA4E@xxxxxxxxxxxxxxxx
> > Hello,
> >
> > I have been working with the OLAP turorial (for Sql Srv 2000), and I am on
> > the third section -- "Advanced Analysis". On the first part of this
> > section
> > we are creating new Dimensions. Using the wizard, I create an Account
> > dimension
> >
> > Account
> > Acount ID
> >
> > which contains the following members:
> >
> > Dimension Members
> > All Aco***
> > --- ~Assets
> > --- ~Liabilities
> > --- +Net Income
> > ------ -(Net Income Data)
> > ------ +Net Sales
> > ------ -Cost of Goods Sold
> > ------ +Gross Sales
> > ------ +(Net Sales Data)
> > ------ -Total Expenses
> > --------- +General & Administration
> > --------- +Information Systems
> > --------- +Lease
> > --------- +Marketing
> > --------- +(Total Expense Data)
> >
> > These memebers are not columns in fact tables or dimension tables (are
> > they?) Are these built-in members? How are these members generated? Is
> > it
> > possible to create additional Dimension members without using the wizards?
> > How is this done?
> >
> > Thanks,
> > Rich
>
>
>
.