Re: How are dimension deletes handled in AS2000?

#1

how do you populate your dropdownlist?
from the cube? from the database?
what is your current query to retrieve this list?

"Saru via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Quote:

How is dimension data deletion handled usually?

The Product Dimension holds a list of all products. Some of these are
deactivated in the OLTP in time.

Since we have sales related to the product in the warehouse, we need to
show
the product in a product dropdown only if the product was active for that
month. But we cannot use a filter to check against the sales measure
because
we don't want the product list to be sensitive to sales, only to time. If
the
product was active for a month, then it should be available in the
picklist
even if there was'nt any sale for that month.

The reporting tool will be reporting services
How can I model the warehouse for this?
What changes do i need to make to the cube for this?

Can someone please help me with the problem

thank you!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1

#2

From the cube. I just select all the members and list them.

thanks

Jéjé wrote:

Quote:

how do you populate your dropdownlist?
from the cube? from the database?
what is your current query to retrieve this list?

How is dimension data deletion handled usually?

[quoted text clipped - 19 lines]

thank you!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1

#3

ok...

but to get the list you have an MDX statement, what is your query?
RS use queries to populate dropdown lists.

The only solution I can see is if you can just display 1 dimension:
create a new dimension called "product of the month"
put in this dimension only the targted products + 1 product called "others"
(with a ID = -1 for example)
add a column in your fact table :
"PorductOfTheMonthID" and map the dimension to this column

then use this dimension in your report.

you have to do a full process of the dimension every month

"Saru via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Quote:

From the cube. I just select all the members and list them.

thanks

Jéjé wrote:
how do you populate your dropdownlist?
from the cube? from the database?
what is your current query to retrieve this list?

How is dimension data deletion handled usually?

[quoted text clipped - 19 lines]

thank you!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1

#4

I use select [dim].allmembers to get a list of members.
thanks for your suggestion, but I need to have more than one picklist.

Is this kind of a scenario not common then? If it is not, then may be I can
ask the users to live with a full dimension list!

thanks again

Jéjé wrote:

Quote:

ok...

but to get the list you have an MDX statement, what is your query?
RS use queries to populate dropdown lists.

The only solution I can see is if you can just display 1 dimension:
create a new dimension called "product of the month"
put in this dimension only the targted products + 1 product called "others"
(with a ID = -1 for example)
add a column in your fact table :
"PorductOfTheMonthID" and map the dimension to this column

then use this dimension in your report.

you have to do a full process of the dimension every month

From the cube. I just select all the members and list them.

[quoted text clipped - 9 lines]

thank you!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1

#5

two issues with deletes:
1) To delete a member requires a full process. That has implications since
it forces a full process of any cubes/partitions which use those members.
Thus I typically recommend only doing it occasionally, e.g. as part of a
quarterly maintenance cycle.
2) You cannot delete a member which has facts in the cube. The system checks
for this and won't let you delete it any fact data remains.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Saru via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Quote:

How is dimension data deletion handled usually?

The Product Dimension holds a list of all products. Some of these are
deactivated in the OLTP in time.

Since we have sales related to the product in the warehouse, we need to
show
the product in a product dropdown only if the product was active for that
month. But we cannot use a filter to check against the sales measure
because
we don't want the product list to be sensitive to sales, only to time. If
the
product was active for a month, then it should be available in the
picklist
even if there was'nt any sale for that month.

The reporting tool will be reporting services
How can I model the warehouse for this?
What changes do i need to make to the cube for this?

Can someone please help me with the problem

thank you!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: How are dimension deletes handled in AS2000?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: How are dimension deletes handled in AS2000? - 08-25-2005 , 06:22 AM

Re: How are dimension deletes handled in AS2000? - 08-25-2005 , 06:59 AM

Re: How are dimension deletes handled in AS2000? - 08-25-2005 , 07:10 AM

Re: How are dimension deletes handled in AS2000? - 08-25-2005 , 08:22 AM

Re: How are dimension deletes handled in AS2000? - 08-26-2005 , 12:45 AM