Jump to content

Report creation fails with ad hoc view using table with group on calculated field


Recommended Posts

I have an ad hoc view that has several calculated measures in the columns and a single calculated field in the group area (this is a table displaying totals data only). When I try to create a report using my ad hoc view, I'm getting the following error:

Error Message

Report design not valid : 1. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1 2. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1 3. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_StartDate 4. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_EndDate 5. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_NumberIfViews 6. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_NumberOfClicks_1 7. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_ClickThroughRate_1 8. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_StayedOnPageForLessThan5Seconds 9. Field not found : public_related_content_tracking_information.DECODED__Related_Content_Algo_Type1_BounceRate


It seems like it's putting the following in front of each of my calculated measures (this is the name of the calculated field that the ad hoc view is grouping by):


When I export the report and check the ad hoc xml files everything looks correct, but the report xml files have these messed up field/measure names. This looks like some kind of bug in the report creation process, is there anyway around this? Thanks for your time.

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...