I have an annual report that uses a spreadsheet. When setting up this year, I got some errors, and walked it back to what looks like an issue with 4.2 vs 4.3
The previous year report works great, but the properties are odd - it shows the Excel tab name as the document (and path).
Here are the files, so the first screen shot above shouldn’t be showing “Bare Bones test”, that’s the name of the Excel tab.
There were several issues with the report, but since I re-pointed to the exact same file, there should be 0 issues. Here’s one - there’s no data even though the report hasn’t changed, and the crosstab is still the same. (Each of the circles has a data element)
here’s the same crosstab with data looking good.
So I have to conclude that there’s some issue with 4.3 not being able to handle a 4.2 file 100%. It’s a whopper of a report so I’m not keen on re-building it.
The mapping of excel based objects is different in 4.3.(designation of objects as dimension, detail or measure)
Have you attempted to do this mapping in the 4.3 report?
I got it all worked out! But I do appreciate the tips …
Things were a little flaky with the Excel fields, mostly I had to add TO-NUMBER to certain fields and it all worked gret. Not entirely consistent with other similar fields, but it’s all working and whew!