Hi, I created a report using a Data Module that is composed by SQL Server relational database tables.
It works fine other than I cannot use Context Filter nor Page Layers. (Both sections are not visible)
Regards
Aren't page layers and context filters dimensional only?
Given that, would it be worthwhile to step back and define the problem be addressed in more general terms? It could be that you can model something which would address the business need, or that you would need to use analogue relational objects in report studio, or you might need to some some modelling and, in addition, some work in authoring.
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_wrkdat_create_page_layers.html#cr_rptstd_wrkdat_create_page_layers
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/c_cr_rptstd_wrkdat_filter_using_context.html#cr_rptstd_wrkdat_filter_using_context
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cr_pps.doc/c_id_ans_filter_data_limitations.html#id_ans_filter_data_limitations