There are 5 tabs in one webi report.
When I go to a tab and chose to edit a filter, it takes me to report filter screen with vertical and horizontal table blocks.
In one of the vertical table block, I can see few filters are already applied with pre-defined values.
However, I need to see the list of values for one BeX hierarchy node and change the defined value. But I can find one sub node is missing when I refresh for list of values.
When I got for data access/edit query panel, I can see all the hierarchy nodes in the list of values for that particular parent node.
Please advise me what is wrong.
BO version is BO 4.1 SP6.
BW version is 7.31 with SP7.
Even if the new report filter is created from scratch removing all filters, it does not help.
In fact, the prompts that are defined at Bex query level(no universe is used, BICS is used instead) show list of all nodes on hitting refresh of report.
But at report filter level, it shows one node less in the list of values.
My question is that how LOVs (at query panel/run query mode)is showing all nodes list when report filter is showing one less.
Which setting hide that node?
As I said you will only see the node at the report level if the report returns that node in the results.
If you do not see that node in the returned results then you cannot select it from the LOV to filter it on the report.
The LOV at the query panel will display all nodes as it will select all the available ones in the database.
You need to go back to created the query to investigate why that node does not appear in the results.
It may be there are no values for the measures (facts) against that node, if there should be you need to investigate why.
It may be the case you create a separate query at the report level that retrieves all nodes, then you could merge the two data providers, that would give you a null measure for that node.
There are 2 BeX queries used for the entire report as seen on editing the query provider and 5 report tabs.
There are several measures used as seen in the result objects pane.
It is with just one tab that does not show all the nodes when editing report filter.
If the query objects has some discrepancy, then other report tabs would have got same issue.
We can do it as a new query but thats not client best fit/solution at this stage. The intention of this case was to find out and fix the current issue for the existing query. We need to trace down and confirm whether the issue is with the report design or something might related to software bug.
We checked the raw outputs of both individual queries at the Bex side and saw all the nodes are retrieved in both.
Do you see them when drag each individual query on to the report?
Is there any row security applied BW side?
Do others in your team see the same after running the report?
Then…
What happens when you rebuild the tab?
i.e. populate the tab with just a table of the data used, then try and filter it, do you see it then?
If everything else holds true, either the tab is corrupt, or the node is filtered out by other filtering.
(BOB member since 2005-01-06)
(BOB member since 2005-01-06)