on 06-27-2017 7:38 AM
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.
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))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Perfect Narashimman K S
Hi via formula pos and substring you should be able to fetch the name out of it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.