January 14, 2009 at 9:45 pm
Hi,
We have a requirement to display the Product sales report in line graph. Users can select any no. of products as input (no. is not fixed) against a particular time period. For all the selected products we want to get the sales for the selcted time period.
For example,
Consider products X,Y,Z are selected as input and the Time period is 2009, then the report should show 3 different lines in graph each one for each product. If the no. of products is fixed we are able to achieve the target. Here no. of products is dynamic hence we are not able to get the solution.
Please provide your valuable suggestions. 🙂
Thanks,
Balaji.
January 15, 2009 at 6:06 am
Assuming you are doing this with SSRS and going against an SSAS source since you are talking about MDX. You can do this with SSRS by using the Analysis Service Query Designer, selecting your attributes and measures, and then in the top right section you can specify your slicers (filters) that you want to use and on the far right if you scroll select the 'Parameters' checkbox for the slicer.
By doing this and placing your products on the Series, months or time attribute on Categories, and your measure in the data area you will be able to display as much data as you want based on the users selections in the parameters.
You can look at some of my screenshots in the following posting if you are not seeing the Parameters selection - Using Reporting Services (SSRS) with SSAS data.
If you are experiencing other issues then provide some more details as to what you are seeing or what you are trying to do.
Thanks.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
January 15, 2009 at 9:42 pm
Thanks for your suggestions. Your assumption is correct and i will try to implement the report as per your suggestions...
Thanks,
Balaji.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply