January 18, 2010 at 5:12 am
Hello Experts,
I really wonder if I ask an impossible question. Because my only purpose is to create a report that render current and previous week's data.
I retrieve data from an OLAP cube.
Can I use two different datasets into one table? Because my first dataset lists the store sales values for a specific week ( based on a report paramater)
And the second dataset lists the store sales values for the previous week.
My desired report layout:
Store Name
Sales Qty (Selected week)
Sales Qty (Selected week - 1)
Any idea?
January 18, 2010 at 7:57 pm
I'm not an expert. I think you can try adding another detail row. and then
put the current information in the original row, put the preview week information in the added row.
January 19, 2010 at 6:46 am
To the best of my knowledge, you can only have one data source for a table.
Why can't you bring all the data in one dataset?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 19, 2010 at 8:34 am
Jack Corbett, thanks for your reply, it helps me.
erdem1973, sorry, I was wrong.
January 21, 2010 at 12:37 am
Thank you very much for your great helps.
I have also tried to set them as a single dataset. And my MDX query is like below:
SELECT [[Measures].[Satis Miktari] ON Columns,
{STRTOSET('[Dim Time].[Week Of Year].&[@MyWeekParamater]') ,
STRTOSET('[Dim Time].[Week Of Year].&[@MyWeekParamater].PrevMember')}
*
{[Dim Stores].[Store Name].allmembers } on rows
FROM
[HCRetailSales]
But I get the following error:
Executing the query ...
Query (1, 8) The dimension '[[Measures]' was not found in the cube when the string, [[Measures].[Satis Miktari], was parsed.
Execution complete
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply