Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Unique count to date - Help

 
   Database Help (Home) -> Datamining RSS
Next:  Data Mining Algorithm Error.  
Author Message
gflorez

External


Since: Apr 23, 2004
Posts: 1



(Msg. 1) Posted: Fri Apr 23, 2004 12:55 pm
Post subject: Unique count to date - Help
Archived from groups: microsoft>public>sqlserver>datamining (more info?)

Hello, can anybody indicate the MDX to calculate Unique Count to date ?

Having two Periods

Period Unique Count Unique Count to Date
First 10 10
Second 4 Unique Count (First + Second)


So if 2 of the 4 items are contained in the first period, then the unique
count should be 10 + 2 = 12

Thanks in advance,

Alex

 >> Stay informed about: Unique count to date - Help 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
CFP: Data Mining 2008 - new date - Apologies for cross-postings. Please send to interested colleagues and students -- CALL FOR PAPERS - Deadline for submissions (new date): 31 March 2008 -- IADIS EUROPEAN CONFERENCE ON DATA MINING 2008 Amsterdam, The Netherlands, 24 to 26 July 2008..

Collation Problem any help - Hello all : My problem is like the following I have an online databse with a latin collation, this database is using ntext and nvarchar values that was with our previous admin ok the problem is in the data is stored should use another collation (the...

Reprocessing a mining model - I'm currently developing a user registration prototype. The aim is to classify certain types of users. However, after the registration I query a decision tree model in Analysis Services with DMX and I want to send the user data into the warehouse to....

Trying to cut down query times - I have a query that is based on two other queries that are based on tables in a database. All of the queries that are used for this final query use grouping and totals. In the application I am making, I need to choose a date range to select the subset....

Update serial number in database - Hi, I want to update specific fields in a existing table in SQL database as below example: L240100001-LG L240100002-LG *serial number is difficult to update one by one L240100003-LG L240100004-LG L240100005-LG change to L240100001-L L240100002-L..
   Database Help (Home) -> Datamining All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]