error when trying to view reports

Hi all

I'm tryung to view the commerce server reports.

When trying to view the EntryPage report i'm getting this error:

[rsMissingFieldInDataSet] The data set ‘TableDataset’ contains a definition for the Field ‘Measures_Visit_Count’. This field is missing from the returned result set from the data source.

[rsErrorReadingDataSetField] The data set ‘TableDataset’ contains a definition for the Field ‘Measures_Visit_Count’. The data extension returned an error during reading the field. There is no data for the field at position 3.

as a result i can't see the visit counts of each page(but i do see the top entry pages)

If i'm trying to browse the EntryPages Cube via the analysis services , i'm getting the correct data.

any idea why this is happening

The error is on all OLAP reports (The only report i can see is the product_sale(whis is not an olap report)

Thanks

Answer this question

error when trying to view reports

PeteJM01
Did you ever find an answer to your problem with rsdata Field missing I have the same problem. I mean the report runs fine I just get a warning and the field is blank but instead of blank I want to show 0 if it is blank. I have done this on measures before saying if IIF(Field!SomeMeasure.IsMissing,0, Field!SomeMeasure.Value) but I have one measure it is not working for. I'm stumped as to why. In fact the Measures it is working on are in the same report and they are calculated the same way. Quirky!
Aleniko29139

Hello Arikve,

First, did you use the Commerce server Data Warehouse import wizard to generate the DTS task that imports data from IIS logs files, Catalogs, profiles, transactions, marketing databases and generates the relevant reports (create or recreate the relevant olap cubes)

This last step adds necessary fields in the relevant tables if they are missing.

Second, did you execute this DTS task for a full import

Regards,
Nfrf
It sounds like the cube and/or measures did not fully process correctly. Try doing a full process on all cubes and dimensions to be sure that all data has been populated correctly.
David Cautley

Sorry

Still didn't find the reason

arik
BobSun
The way I got around this error was to redo my dataset on those datapoints only where I was getting the warning. I later found out that there had been changes in the cube, which have have caused these warnings.

Good luck
LPlate
Hi, I have the same problem. If you'll resolve that, please send me solution.

lenkerovam@cgcc.cz

thanx in advance
luissol

Thanks

I've tried that but still have the same problem.

i've put a profiler on the analytic service and looked at the query that arrives to the dataware house.

Its look fine to me and return the result(with the visit count)
error when trying to view reports

Answer this question