Hi,
We are using BI-IP with BI 7.00.
We need to enter planned Sales quantities for Materials in the Base Unit of Measure. Hence, the Input-Ready queries are designed such that the Material and the Base Unit of Measure will form the Rows (Lead columns) and the Key Figure for sales quantities will form the columns.
In the properties tab for the two lead columns (Material and base UoM), we have specified the Access for Query result as Master Data and "Characteristic Relationship" respectively. The Display type has been set as "KEY" for both of these. However, when we put this Query in a WAD template and give the no. of new lines as 10 in the Analysis Item, no new lines are displayed.
After a lot of experimenting, we found that the problem is because the characteristic Base UoM doesnt have Master Data and hence the new lines are not generated during the WAD execution. So when we remove the Base UoM from the Rows and put them in the Filter and hardcode the restriction, then the new lines get generated.
Obviously this is not an acceptable solution since different materials can have different Base units and we cannot have different Queries based on the Units of measure of the materials.
We cannot also activate Master data for the characteristic since it is a Unit Characteristic and hence doesnt even have a "Master Data" Tab.
Any ideas would be welcome for this.
Regards
Sriram