SolvedPrivate

Using between in Dimension in MDX query

Posted on 2015-01-15
1
10 Views
Last Modified: 2016-02-18
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
Comment
Question by:basile
1 Comment
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40553002
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Troubleshooting Methodology - steps 3 36
How to SQL Trace a SPECIFIC query 24 57
Help with simplifying SQL 6 48
Extract string portion 2 13
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now