?
Solved

Create member

Posted on 2012-04-03
2
Medium Priority
?
324 Views
Last Modified: 2016-02-15
Hi,
I am trying  to create member in my cube -->calculation

CREATE MEMBER CURRENTCUBE.[Measures].[QTY-YTD] AS SUM(YTD([Date].[YQM].CurrentMember), [Measures].[Quantity]), VISIBLE = 1;
The amount does not change when I change the month in the hierarchy
Thanks
0
Comment
Question by:samprg
2 Comments
 
LVL 3

Accepted Solution

by:
Chris__W earned 2000 total points
ID: 37807116
Hello,

The question that first pops up is concerning your Date.YQM hierarchy.  If the levels are not set correctly, it would explain the result of the same amount showing regardless of the month / date specified (as it would be looking at the whole list instead of a group).  

You can verify this by opening the project in BIDS and browsing the Date dimension.  The middle pane should have a hierarchy for YTD.  If it does not, either create one or use a different hierarchy that is built.

I've attached a screen shot of an example.  Attach a screen shot of yours if you're unsure.

Thanks,
Chris
DateHierarchy.jpg
0
 

Author Closing Comment

by:samprg
ID: 37807725
Cool
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Ready to get certified? Check out some courses that help you prepare for third-party exams.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

609 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