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 ???
