____ JK - BI Blog ____

In Reports where some objects are set to be shown/hide based on some expression/filter condition etc. There Could be some white space issue between the objects on the report( i.e. when few objects are hidden in the report, the white space between the objects will accumulate and displayed as a big gap between the objects on the report). Following are few ways using which we can handle this kind of issue: 1. Remove the Gap between the objects in the report layout. 2. Or put a text box and make the border the same as the background color and apply the same show/hide action on it. 3. If you are using a table/matrix then instead of putting the space between objects, just add one static row above the column header for the table/matrix and make the border color the same background color. below is one approach: The report before any space handling: -----------------------------------------------------------------------------  Report Preview when all the obj...

Problem statement: Sometimes we have very large dimensions in the Cubes and when we create Excel Reports using those dimensions in the Filter etc. We face the excel filter limit restriction, only 32,000 vales are allowed in the filter. But still, we want to create the report and the report should work properly for the end-users. Solution: We can achieve this by creating the Groups where we can group the dimension values and create hierarchy using this Group description and dimension values. Say suppose we have a dimension Employee. In the Employee Dimension, we have around 150,000 records. So then we create a Report using the Employee in the filter. The Excel Report will through an error when we select the values for the employee as the number of counts is more than 32000 for the Employee dimension. So for this, we can create h new column in the Employee dimension which is Employee Group and bifurcate the values into these groups. As the number of ...