|
Home > Archive > MS SQL Server OLAP > December 2005 > How to create new Dimension members?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to create new Dimension members?
|
|
|
| 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@discussions.microsoft.com> wrote in message
news:8D223F41-CFC6-4CB7-B1E9- F6DE3521EA4E@microso
ft.com...
> 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
| |
|
| 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:
> 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@discussions.microsoft.com> wrote in message
> news:8D223F41-CFC6-4CB7-B1E9- F6DE3521EA4E@microso
ft.com...
>
>
>
| |
|
| 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:
[color=darkred]
> 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:
>
| |
|
| 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.[color=darkred]
| |
|
| 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:
> 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.
>
>
>
|
|
|
|
|