Show all pivot -row -variable -values (column headers) 1

[fghNoVaDC]

Specifically, those which have empty data columns (under their variable headers) in the report results, (i.e. those variables which have no data values satisfying the crosstab query).
(How) can this be done?
Suppose: One wishes to have a BO query report, which has a number of crosstab tables showing different data for ...say four regions of the world (4 columns/4 pivot row variable values). One (or more) of the regions (on one or more of the many crosstab tables within the single report query) has no data which satisfies the filtered crosstab.
I am having trouble determining how to have all of the 4 regions shown (headers for each of the 4 columns to appear) in the report (as occur with the crosstab tables having pivot-body-variable-data-values exist for all regions) when there might not be any data for a particular crosstab's region. Blank "Body variable" cells appearing beneth the variable's value/region/col.header (or a data place holder of 0) is desired. Instead the crosstab table only shows the 2 or 3 (regions/column headers/variable values) which have data (to report beneath). This produces a multi-tabled (crosstabed) report which has varying numbers of columns (1-4) across each crosstab, rather than each crosstab having all four regions show on the report (some without data).
[If a crosstab within the report is right-clicked upon, a drop-down menu appears which has a "Format Crosstab" choice, if clicked there appears a menu which has a "General" tab, where there is a "Display" section, with a checkbox to "Show Variable Header". However, clicking/checking this box does not produce the desired/any result.]
Does anyone have any insight as to how to show all regions/column-headers for all crosstab tables within one report/query?
Apologies for lack of clarity or technical terminology resulting in abundant slashes & parentheses. If a more easily understood or simpler-asked question can be provided, please inform. Research has been exhausted, and a strong desire exists to not make a request boardering on 'others doing my homework.' There seems no mention of such possible functionality within several manuals -Core, Intermediate, Advanced Reporting Concepts, or Variables and Functions in Advanced Report Creation.
Masseurs Blom? Krandle? anyone having a depth of knowledge in this arena?
Sincerest gratitude regarding your time!!
-Stumped

 

[skrandel]

This requires 2 data providers. 1 as you have it; and another that retrieves all the "master data" values.

Build your crosstab using all the objects of your original data provider and the dimension in question from your new one.

This does not work if you have sections or filters of any kind in the report.

Steve Krandel
VERITAS Software

 

[fghNoVaDC]

Thank you for your reply Steve.
We had changed our multiple crosstab report, which was made-up of more than 20 very long crosstab formulas. Although the report output was to be the same, the change was made to the crosstab functionality by seeking to take advantage of the format-filters capability. This was in an attempt to shorten the 25 minutes of processing time it took for our report to calculate and display when refreshed and re-pulling from the data warehouse. Additionally our variables had become so numerous and/or our report's variable formulas used in each crosstab so long, that it seemed any further additions to the way it was, either adding a new variable or crosstab, would cause the program to crash. An error window (with a blue bug?) would often appear. This would always cause the BO program to cease operating?
Many thanks again, for the generous response to our column header question. Unfortunately, it seems we will need to return to using the very long crosstab variable formulas (which essentially filter the master data via numerous, lengthy "Where" statements). This is, again, to be able to have ~all four region headers to be displayed on the report for each crosstab. -For uniformity, or ease in VP analyzing I suppose. Also, to handle data groupings beyond single filters, -embedded If/Then/Elses weren't working when seeking to design a complex filter?
At first utilizing the format filters capability seemed to be a powerful time saver by decreasing the refresh calcs time of 25 minutes down to 12 min. or so. However, several crosstabs required multiple conditional filters across multiple variables (which we were attempting to achieve via utilizing complex filters and/or imbedded If/Then/Elses). Though when these were added, they either didn't work or quickly took our processing/recalc'ing time back above 20 min.
Therefore, when or if, you/anyone might have a moment, final follow-up questions would include:
1- Is this refreshing the data calcs/run-/processing time of now again approx. 25 min. something which we may not be able to improve upon? (while being able to generate the same desired report output)
2- This error window, which contains a blue bug icon, that appears upon BO crashing ~20min+ into refreshing, -Is this a time-out error? How can it be avoided now that filters aren't able to help, or save us the recalc time?

Thank you all for the existence of this valuable forum. (I have not comm.'d through BOB before, though that seems great as well.)
still struggling, yet believing there's a way...Frank H.