Can we link or import PI data in OLAP Cube using PI OLEDB for business related data manipulations
we would like to link our business data which is in SQL to our real time data which is in PI.
Absolutely you can use PI OLEDB to bring data into an OLAP cube.
From a licensing standpoint users of the OLAP cube will need a PSA (PI System Access License) or you will need a PSA Server license for the server hosting the OLAP instance.
could you please send us highlevel steps for that....do you have any document on this
Sure. Check out the several documents in the library here:
Intro to PAG Integrating PI 2010 with Microsoft BI
as well as in the OLEDB section
White Paper - Connecting OLAP with PI
@Sandeep: just checking... did the documents referenced by Matt help? Anything else we can help you with or discuss here?
Retrieving data ...