Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Named Set Help		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

n/a

30 Posts
Posted - 03/15/2005 :  21:12:59  Show Profile  Reply with Quote
HI Igor and fellow RP guru's

What is the MDX to create a named set for a time dimesion to always show the current month based on system date??

This would allow users to create a report once that always shows the current month results. Therefore preventing the need to change the time filter on numerous reports each month.

TIA

Ryan

admin

1646 Posts
Posted - 03/17/2005 :  20:22:33  Show Profile  Reply with Quote
tail(filter([MyDate].[Day].members, not isempty([MyDate].currentmember)),1).item(0)
Go to Top of Page

n/a

30 Posts
Posted - 03/20/2005 :  19:07:15  Show Profile  Reply with Quote
Igor,

This would be a good solution if the time dimension does not extend beyond today!! For most of our customers they have budgets or forecasts that extend beyond the current day.

Can you advise the formula that uses system date to determine what the current day is in the time dimension??

thanks
Ryan

Cheers
Ryan
Go to Top of Page

admin

1646 Posts
Posted - 03/21/2005 :  18:08:32  Show Profile  Reply with Quote
Ryan,

You can create a member property called Is_Current_Date_Flag. The MDX would be:

Tail(Filter([MyDate].[Day].members, [MyDate].Properties("Is_Current_Date_Flag") ="yes" ),1).item(0)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page