I have successfully setup drill through in my SAP BPC MS 7.0 SP5 development environment. I've configured the query to pass parameters to the query using the %dimension% method. I'm able to pass only two parameters to the query and time does not seem to be accepted. Below is my current query:
DRIVER=SQL Server Native Client 10.0;SERVER=BPC_DB_DEV_CONS;UID=JrnDrill;APP=2007 Microsoft Office system;WSID=CEN103118;DATABASE=Finance DataMart;
SELECT stgDrillTest.ENTITY, stgDrillTest.ACCOUNT, stgDrillTest.AMOUNT, stgDrillTest.INV_DATE, stgDrillTest.INV_ID, stgDrillTest.JRN_DATE, stgDrillTest.JRN_ID, stgDrillTest.JRN_LN, stgDrillTest.TIMEID, stgDrillTest.TEAM , stgDrillTest.SUBTEAM FROM "Finance DataMart".dbo.stgDrillTest stgDrillTest WHERE (stgDrillTest.ACCOUNT='%ACCOUNT%') and (stgDrillTest.ENTITY='%ENTITY%')
ENTITY ACCOUNT AMOUNT INV_DATE INV_ID JRN_DATE JRN_ID JRN_LN TIMEID
Can I pass more than two parameters to the query? Should I be able to pass time as a parameter? My time dimension is in the format yyyydd.