Hi Guys,
I have a issue that I cant seem to sort out.
I have a cube published in my Framework Model.
Then I have a report studio report, that uses this cube as a source.
The report also has a date prompt.
The problem is this, when I select 2009 data in the prompt, the report works fine, if I select 2010 data, it shows zero values, although the cube does have 2010 data, same format and layout and scope as that of the 2009 data.
I have even tried removing the cube from the model, re-adding it and republishing it, but this also didnt work.
Any ideas?