BPC 5.1 (SP0) Book Publishing from Excel
I'm trying to configure Book Publishing for the first time and I'm having trouble getting any results. I have a template, it validates OK. I have a report that definitely has data showing for the current view and for combinations of the dimension that is listed in the !VARYKEYS field. When I try using the Wizard to publish the book everything goes OK in the various selections, and I can see it briefly open the template and the report in the background, but I get a dialog reporting that there is 'no data for the members specified in the report or current view'. I have re-confirmed that there is data. I've tried specifying every dimesion in the !FIXEDKEYS, and also just a single dimension. I have tried it with and without a Suppress Criteria. Am I missing something obvious?
I have experienced the same issue, for some reason the suppression also looks at your current view. Try setting your current view where data will be found for each intersection like account=net income and datasrc = totaladj.