Linking reports

Does anyone know if it is possible to link two reports together?
For example, if you have a report showing customers with the number of
orders they have placed, can you then link to another report showing
details of the actual orders.
Hope this makes sense.
ChrisYes possible using drill through reports.
Amarnath
"chris.j.stubbs@.gmail.com" wrote:
> Does anyone know if it is possible to link two reports together?
> For example, if you have a report showing customers with the number of
> orders they have placed, can you then link to another report showing
> details of the actual orders.
> Hope this makes sense.
> Chris
>

Linking Dimention and Fact tables

Hi,

I have two tables, cds_statday with all transactions for all customers (Meta_ID, fact table)

and part of customers in Group table(PlayerID, dimention table)

I can't process the cube because SSAS can't find players from fact table in demention table. What can I do?

http://public.fotki.com/obulay/image/screen.html

OL

Here is Error Message
Errors in the OLAP storage engine: The attribute key cannot be found: Table: cds_statday, Column: Meta_ID, Value: 775. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Agroup of Dimension: Group from Database: SSAS, Cube: Analyst, Measure Group: Cds Statday, Partition: Cds Statday, Record: 21216.

OL

|||

Process the dimension table before the measure group. If this does not work you probably have a problem with the relation between the dimension table and the fact table. You might have keys in the fact table that are not included in the dimension table.

Regards

Thomas Ivarsson

|||

found the reason on the forum. I changed processing settings to ignore missing attributes

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=123784&SiteID=1