Problems with filters

Question

1.00/5 (1 vote)

See more:

Hello ,
In short, I am trying to develop a BI application using the tool SQL SERVER 2012 .
The everything went well and properly.
I described my problem:
The BI application is developed for an industrial company . The work is on 3 Part times ( Morning , Afternoon , Night ) .
The dates in the table "Date" are integers (for EXP ' 2015-07-22 ' will be 20,150,722 ) for performance reasons ( Loading data ... )
Also the hours are converted in enteger ( for example : id = 1 returns to time : 0h-1h , who is on Night post) .

==> Morning 06h to 14h
==> Afternoon 14hh to 22h
==> Night from 22h to 06h

The problem is how to calculate such a measure in the Night post.
The answer is clear : SUM of two dates, the first from 22h to 00h
and the second from 01h to 06 h . but how ???????
In SSAS , you can not filter twice.
Please I need help.
Thank You

Posted 22-Jul-15 0:50am

Member 11603655

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-07-22T01:16:00

Solution 1

I really suggest dropping the idea of using integers instead of datetime. That kind of logic will make it very difficult to manipulate and query the data.

What comes to performance, SQL Server handles dates internally using numbers so the difference between integer and date shouldn't be meaningful.

Posted 22-Jul-15 1:16am

Wendelius

Comments

Member 11603655 22-Jul-15 7:39am

What about making a querry MDX which join the two select ????

Wendelius 22-Jul-15 10:05am

This could probably be done but why create a workaround for a problem which is caused by doing things in non-standard way?