"FCCS_YTD Input" not allowing for drill through to work from a form
Hi, we are loading data into FCCS which is YTD and therefore we use the "FCCS_YTD Input" view member in the load. When we run the load the data is loaded to the FCCS_Periodic view member(presumably there is some processing done when loading data into the cube to calculate the periodic values). The problem we have is that when we try to drill through from a form the query being generated does this for "FCCS_Periodic":-
DIM PARAMS:[[Base Entities].[D004], D004, [R0004].[40000000], 40000000, FCCS_No Intercompany, [Custom3].[No Custom3], No Custom3, FCCS_Managed Data, [FCCS_Mvmts_Operating].[FCCS_Mvmts_NetIncome], FCCS_Mvmts_NetIncome, FCCS_Local GAAP, [Product].[No Product], No Product, [Site Status].[No Site Status], No Site Status,