Solved

Date dim issue in report studio

Posted on 2008-10-16
3
690 Views
Last Modified: 2010-10-05
we have 8 reports, and each report could be seen with different time line daily, weekly,monthy, yearly...is there any way in report studio to dertermine date range dynamically and have one report tht takes tht parameter and run the repot.....currently for each timeline we have one report so if v have 8 reports and 5 timelines....it will be 8 *5 .....tht i dont want....one other solution is to make a routine in FM to determine date rage from date dim..and give tht to report studio.....
0
Comment
Question by:muhammadaqeel
  • 2
3 Comments
 
LVL 12

Expert Comment

by:RWrigley
ID: 22734897
I'm not sure I follow your report logic.  How is the date range determined for each report?  You can easily design your report to generate things like year to date, month to day, etc off of a single parameter.
0
 

Author Comment

by:muhammadaqeel
ID: 22735937
okey v hav one prompt page ...that allows user to select the report and select the time line...lets say repror is sales and time line is yearly.....so wht report authers are saying as sales report could be daily, weekly,monthly or yearly they hav to create 4 reports.....as inorder to get the date for weekly and monthly they hav to create a join to the date dim at report level....
0
 
LVL 12

Accepted Solution

by:
RWrigley earned 500 total points
ID: 22737330
uh...no.  

If the datasource is dimensional, then you need to create a dataitem that unions four filtered set expressions together.  The whole expression will look :

Union(
  union(
    filter([cube].[Time].[year].[year],?ReportType?='Yearly'),
    filter([cube].[Time].[year].[month],?ReportType?='Monthly')
  ),
  union(
     filter([cube].[Time].[year].[week],?ReportType?='Weekly'),
     filter([cube].[Time].[year].[day],?ReportType?='Daily')
  )
)

The key to this is the filter expression; only one of them will be "true", which means that the other three expressions  will return an empty set.  ENd result is that you only get the set of members for the selected time period.  Substitute the level expression for whatever the required set expression is for each report type.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Historical Data of SSRS Reports 1 73
web based reporting not a saas 9 62
Jaspersoft iReports - SSL Certificate Installation?? 3 98
SSRS hide tablix 1 285
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 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