Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 53
  • Last Modified:

Using between in Dimension in MDX query

using query below: i'm only asking for 8/31/2014 - 12/31/2014. However, i'm getting also 2015 data for example,

for 8/1 i get 8/1/2014 and 8/1/2015 (i'm only looking for 2014 data, what have i done wrong in the below statement ?

select {[Dim Date].[Date].&[08/01/2014]:[Dim Date].[Date].&[12/31/2014]}
 on rows,

{[Measures].[Available Time Net],[Measures].[Logged On Time Net]} on columns
from [OTS Agent Time Net Data]
0
Auerelio Vasquez
Asked:
Auerelio Vasquez
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
I imagine you have not defined the date as a date.

Go to the relevant dimension, and click "Add Business Intelligence" - Next - "Define dimension intelligence" and change Dimension Type to "Time".
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now