Fixed reports in Reporting Services using SSAS

I am quite new with Reporting Services so appologies if I'm asking a
really simple question without relaising it.
I have a Analysis Services cube that I'm querying from Reporting
Services 2005, I'm wondering how I can create a fixed style report that
has specfic members from one dimension in one axis and specific members
from another dimension in another.
Eg:
Jan Feb Mar Apr May Jun Jul Aug
Cost1 2 6 5 8 88 0 8 8
Cost15 0 0 0 0 0 6 54 5
Cost65 52 5 545 1 42 55 54 455
Cost15 545 0 555 0 22 2252 5 55
Cost95
I have found that it's quite easy to create this format in a dymamic
fashion but I have had no hope in doing so with fixed members in both
axis.
Any help would be much appreciated.
Thanks
SimonI think that you can make 1,15,65,15,95 members as a 'named set'
hope that helps
-Aaron
sk wrote:
> I am quite new with Reporting Services so appologies if I'm asking a
> really simple question without relaising it.
> I have a Analysis Services cube that I'm querying from Reporting
> Services 2005, I'm wondering how I can create a fixed style report that
> has specfic members from one dimension in one axis and specific members
> from another dimension in another.
> Eg:
> Jan Feb Mar Apr May Jun Jul Aug
> Cost1 2 6 5 8 88 0 8 8
> Cost15 0 0 0 0 0 6 54 5
> Cost65 52 5 545 1 42 55 54 455
> Cost15 545 0 555 0 22 2252 5 55
> Cost95
> I have found that it's quite easy to create this format in a dymamic
> fashion but I have had no hope in doing so with fixed members in both
> axis.
> Any help would be much appreciated.
> Thanks
> Simon|||I think you need to organize the way your data gets outputed. If you manage
to create a "grid" of data in the form you want it to, you could just use a
fixed table and add the fields to the column or row that you want it to.
That would probably mean a lot of crossjoins or unions on the coloumns to
get the months tagged right, and have the different costs as rows.
Sorry to ask, but why do you want to do it fixed? This is sort of what
matrixes are made for, contrary to the tables.
Kaisa M. Lindahl Lervik
"sk" <simon.m.knight@.gmail.com> wrote in message
news:1159979952.751107.275360@.m73g2000cwd.googlegroups.com...
>I am quite new with Reporting Services so appologies if I'm asking a
> really simple question without relaising it.
> I have a Analysis Services cube that I'm querying from Reporting
> Services 2005, I'm wondering how I can create a fixed style report that
> has specfic members from one dimension in one axis and specific members
> from another dimension in another.
> Eg:
> Jan Feb Mar Apr May Jun Jul Aug
> Cost1 2 6 5 8 88 0 8 8
> Cost15 0 0 0 0 0 6 54 5
> Cost65 52 5 545 1 42 55 54 455
> Cost15 545 0 555 0 22 2252 5 55
> Cost95
> I have found that it's quite easy to create this format in a dymamic
> fashion but I have had no hope in doing so with fixed members in both
> axis.
> Any help would be much appreciated.
> Thanks
> Simon
>|||Thanks for your reply,
The report needs to look exactly the same as an Excel based matrix
report that we use. the format is defined by our corporate entity so I
can't change it.
Thanks
Simon|||Excel isn't a reporting platform.
Tell them to eat shit
-Aaron
sk wrote:
> Thanks for your reply,
> The report needs to look exactly the same as an Excel based matrix
> report that we use. the format is defined by our corporate entity so I
> can't change it.
>
> Thanks
> Simon|||Thanks for your suggestion, I'll give it a try!
Still, it must br possible to create a fixed grid report. I'll try your
suggestions and the others posted here..
Simon|||There's a discription in Chris Hays' blog about Horizontal Tables. Might be
what you need:
http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx
As for using a matrix, what parts are different between your Excel report
and a matix based report?
Kaisa M. Lindahl Lervik
"sk" <simon.m.knight@.gmail.com> wrote in message
news:1160074016.884219.105770@.i42g2000cwa.googlegroups.com...
> Thanks for your suggestion, I'll give it a try!
> Still, it must br possible to create a fixed grid report. I'll try your
> suggestions and the others posted here..
>
> Simon
>|||Thanks for that - I'll look into it.
The difference between my Excel report and a matrix based report is
that the Excel report is completely static. just a table with fixed
members in each axis. The members in each axis need to be fixed like a
PL report (see example)
http://www.ilytix.com/ImageFiles/Popup_P&L_Report.gif|||OK, the picture looks like a standard RS table. As long as your output is in
a usefull format, you could use a RS table. If you make sure you always get
the right data out (like you know you only get the same 4 rows of growth),
you can probably use a dynamic table. Or you can really hard code it,
returning several data sets with one row of data in each and creating
several single line tables put close in the report designer so they look
like one big table.
If your data set returns both dynamic growth and dates (months in your first
example), you could solve it by using a matrix. Make a row group for your
growth, and a column group for dates. "Pad" your data set to make sure you
always return the same number of months for dates, so you always get the
same number of month columns, and the same for the growth numbers. You might
have to tweak your mdx statemement a bit, but that's probably more usefull
than customizing the table.
Kaisa M. Lindahl Lervik
"sk" <simon.m.knight@.gmail.com> wrote in message
news:1160083140.237336.110450@.i3g2000cwc.googlegroups.com...
> Thanks for that - I'll look into it.
> The difference between my Excel report and a matrix based report is
> that the Excel report is completely static. just a table with fixed
> members in each axis. The members in each axis need to be fixed like a
> PL report (see example)
> http://www.ilytix.com/ImageFiles/Popup_P&L_Report.gif
>