hi.. Try creating a view with these tables and bring in all the necessary fields. Attach the view to the query data source. Now try to process the cube. Hope this helps.
On Tue, Jul 21, 2009 at 2:09 PM, Gokhan CAN <gokh...@agcyazilim.com> wrote: > > > I am trying to build an OLAP cube … > > > > I created a Query > > > > My query is like below. > > > > Reqtrans > > Inventtable > > Relation > > Inventtable.itemid = Reqtrans.itemid > > JoinType > > 1::1 - Innerjoin > > Purchline > > Relation > > Purchline.inventtransid = reqtrans.inventtransid > > JoinType > > 1::1 - Outerjoin > > Purchtable > > Relation > > purchtable.purchid = purchline.purchid > > JoinType > > 1::1 - innerjoin > > InventDim > > Relation > > Inventdim.inventdimid = Reqtrans.inventdimid > > JoinType > > 1::1 - Innerjoin > > > > But when I try to add a field from purchtable to pivottable I get this kind > of error. > > > > An error occurred while processing the 'ReqTrans' partition of the > 'ReqTrans' measure group for the 'ReqTrans' cube from the DAXOlapDatabase > database. > > Server: The operation has been cancelled. > > > > But if I remove field from pivot I do not get error. > > Can anyone help ?? > > > > I also want to put a field from Configtable.But I can not define a relation > to configtable with Reqtrans.itemid and Inventdim.configid ??? > > > >
