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 Acocunt
--- ~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

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 (AT) discussions (DOT) microsoft.com> wrote

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 Acocunt
--- ~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:

OK. I think I answered my own question. I created a new dimension and added
a custom member to it. Then I observed that the contents of the respective
columns are where the members come from. I appologize in advance for my
newbiness .

Your help has been appreciated.

Rich

"Rich" wrote:

Sorry, I misread..

Members of a Dimension come from the source data. In the case of the
Account Dimension in the tutorial the members come from the Account table in
the Foodmart2000 sample database.

No need to apologise.

I recommend the following book:

MDX Solutions
Wiley - George Spofford
ISBN: 0-471-40046-7

Enjoy

Thanks again for your replies, and for the book reference. I will check that
book out.

Rich

"Clint" wrote: