DISTINCT Values in WEBI

We always not prefer to see the duplicate records in report. in some cases the output of the universe may have duplicates.
We can remove the duplicates in WEBI layer. Follow the below steps to remove duplicates.
Go to Query Panel in Webi,
Q1
Click the properties and uncheck the “retrieve the duplicate rows”. By default, it is checked
Q2 
Thanks. Please let me know for any issues.

    Comments

    Post a Comment

    Popular posts from this blog

    SSIS BULK INSERT–“fetch a row from OLE DB provider "BULK"…”

    Image
    I created a simple SSIS Package using “Bulk Insert Task”, here am trying to upload the data from text file into my database. I have configured everything and ready to go, while execute the package, the error was thrown “[Bulk Insert Task] Error: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information”. Then i checked the column delimiter and fixed the issue, If you are using comma separated value then use “Comma {,}” as column delimiter.
    Read more

    SSRS–Maximum request length exceeded

    Image
    My friend had an issue in deploying the report to report server. It is a dashboard so it has colourful charts and many thing. The size of the report is around 4 MB. When he deploy the report he got an error message “There was an exception running the extensions specified in the config file. ---> Maximum request length exceeded." When we work around, we found that the default size of the file to upload is less, we need to increase the size manually in web xml config file. To find the web xml config file, go to C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer Open the Web file and add maxRequestLength="2097151" as below, then close the solution and open. Now deployed the report.
    Read more

    WEBI Query Properties

    Image
    By using query properties, we can restrict the records to display in a report. Please check the options in query properties Max rows retrieved - Maximum number of rows of data that are displayed when a query is run. This is related with Sample Result set. For example, if you give 1000 rows in "Max rows retrieved" then 500 rows in "Sample Result Set" then you will get 500 rows only. Also it can be restricted based on the administrator security profile. Sample Result Set - It determine the Maximum number of queries returns. This restriction is applied in database level. Fixed - At each data refresh, query returns the same rows when Fixed option is marked. If not then on each data refresh, query returns different set of sampled rows Retrieve duplicate rows - In some cases, in database, the same data may be repeated over many rows. You can restrict those data using this option.
    Read more