Skip to Content
avatar image
Former Member

Removing unwanted text from the 'Webi_Properties' result field

Hi,

I have a query while building report on CMS DB.

The BO server version is BI 4.2 SP3 P7.

Requirement - Create a report which will fetch BEx query details which is available in the system OR Create a report which will provide information of all reports in the system with the reports data source details

I have created a report with below details and it is fetching all the properties details in the webi_properties column

However; the column is bringing all other data such as <xml> DSID, DPNAME etc as well which needs to removed and only the data source names should be listed in the column.


Could anyone please help to find out only the DS/DP name and not all the details.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jun 29, 2017 at 09:54 AM

    Agree with all others here.

    I had created this for DPNAME, you can edit to get whichever parameter you would like (also using just one variable or by keying formula in cell !)

    DP_NAME_START
    =Pos([Webi_Properties];"DPNAME")+8
    
    DP_NAME_END
    =Pos(Substr([Webi_Properties];[DP_name_Start];50);Char(34))
    
    DP_NAME
    =If([DP_NAME_START]<9;"Not Available";Substr([Webi_Properties];[DP_NAME_START];[DP_NAME_END]-1))
    
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Narashimman.

      Having one concerns, it only fetching 1st DS/DP name from the list, and we have multiple DS/DP name. I have tried with Loop condition but no success on this.

      Could you please let me know how to fetch multiple DS/DP name from the list

  • Jun 27, 2017 at 02:04 PM

    I dont think there is a direct way to get this as we dont have a individual object for the property which you are looking for. Instead you can create a variable at your report level and implement string processing logic to get the data which you require.

    Thanks

    Mani

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 28, 2017 at 01:21 PM

    Hi via formula pos and substring you should be able to fetch the name out of it

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 02:38 PM

    Yes there is no direct way to query only DS/DP for all the WebI documents today. But I believe, this can be made as an enhancement for the BI on BI driver functionality, as in WebI the capabilities to find out DS/DP using the functions like =DataProvider(obj) / =UniverseName(dp) etc already exists. So, by combining the functionalities of both WebI and BI on BI driver by enhancing the existing functionality, in BI CMS System database sample universe this can be exposed as for each WebI document how data providers are there and what are those.

    Add comment
    10|10000 characters needed characters exceeded