COGNOiSe.com - The IBM Cognos Community

Hi All,

I am attaching the report spec from sample greatoutdoorsalesen cube. If I set a page break to my branch data item in page 2 I am getting a circular reference error. Not able to find the root cause.
GEN-ERR-0005 The reference to the query item 'AllCountry' forms a circular reference .

Scenario:

Report has two pages,
First page showing a crosstab with 1 product in row , revenue as measure and YTD as column.
Second Page showing crosstab Product in row nested to Branch and revenue as measure and YTD as column.

We have a prompt page with 3 prompts from SalesRegion Hierarchy .Country ->Branch->Employee

Country - query used for prompt -Descendants(set([Asia Pacific],[Americas]),[great_outdoors_sales_en].[Sales regions].[Sales regions].[Country])
Branch -Descendants(set(#promptmany('prmCountry','mun','[Sales regions]')#),1)
Employee -Descendants(set(#promptmany('prmBranch','mun','[Sales regions]')#),1)

Now we are adding slicers to filter the main report by prompt value chosen.

Slicer on main Query - #promptmany('prmEmployee','mun','[All Branch]','set(','',')')#
[All Branch] -#promptmany('prmBranch','mun','[AllCountry]','Set(','',')')#
[AllCountry] - #promptmany('prmCountry','mun','[CountriesGroup]','Set(','',')')#
CountriesGroup -Descendants(set([Americas],[Asia Pacific]),[great_outdoors_sales_en].[Sales regions].[Sales regions].[Country])

Please help me resolve the error. If you remove the page break in my page 2 , the report would work .

Thanks,
Nithya

hi guys,

Any suggestions on this, I am not sure how page break creates circular reference.
Can anyone help on this?

thanks,
Nithya

I am still stuck in this report , awaiting your suggestions to move forward!! IBM says they are going to create an APAR, but I still feel its something wrong with my report.

Please do let me know if you are not able to access the attached report.

Thanks,