About DerekJ

DerekJ

Hi thereI am asking if anyone knows if there is a system table that I can access to view the filters put on remote tables? We pull hundreds of tables from our SAP ECC system and we should have a filter for Client on each table, but some have slipped ...

DerekJ

I am using the Free-hand SQL connector and have configred the exact same connection in my Test and Prod BOBJ Servers. However when I promote the Webi report via CMC from Test to Prod, the connection errors saying "You do not have the right to access ...

DerekJ

Hi I just want to confirm I'm not doing anything wrong and there is no workaround havng to build out any currency conversions in the 'end' Space raher than a 'shared' view from another space.I am getting an 'insufficient privilege' error on the TCUR*...

DerekJ

Hi ThereI am trying to get a dropdown list of values on a filter prompt on a Webi report. A direct connection to SAP HANA as a datasource brings back this functionality, however when I use Free-hand SQL query for SAP Datasphere (as SAP HANA does not ...

DerekJ

I completely get the restriction in Admin console that a user cannot assign their own roles. However I have discovered that under scoped roles as we add new spaces and assign to the relevant role the assignee does not get those spaces applied to them...

DerekJ

This is still an issue, I cannot believe that the two flagship Data applications for SAP cannot still be used together for schedules, especially when this was raised as an issue years ago. Has anyone heard any progress on this?

DerekJ

Found my own solution, pasting here in case anyone needs it...SELECT SCHEMA_NAME, VIEW_NAME, DEFINITIONFROM "SYS"."VIEWS"WHERE 1=1AND SCHEMA_NAME = 'EUK_SOURCE_TABLES'AND DEFINITION LIKE '%MANDT%' AND DEFINITION NOT LIKE '%"MANDT" =%'ORDER BY "VIEW_N...

DerekJ

Hi, thanks, yes I tried that, but thought it had not worked as the query was the same query number so I thought it had not changed. But on closer inspection, the source has changed, so both queries are now same source. I was assuming it would have sw...

DerekJ

Hi XaviPolo, yes, sorry is Julian is correct, it's not the currency tables themselves, but the calculation I'm doing in other spaces. Yes I thought persisting would fix, but that's not ideal. If I find any solution I will share

DerekJ

Can somoen help clarify something on Step 1.6:Enter the Redirect URI to specify where OAuth access and refresh tokens are returned in SAP BI Platform. Note that, in SAP BI, OAuth access and refresh tokens are saved and managed per user at the SAP BI ...

User Statistics

User Activity

System table to view Remote Table Filters

Free-hand SQL Webi Promotion to other server, Connection not working

insufficient privilege currency conversion to shared spaces

Webi Query Filter Value From List not available using Free-hand SQL query

Scoped Role and new Space assignment does not apply Space to assignee

Re: SAC publication on DWC

Re: System table to view Remote Table Filters

Re: Free-hand SQL Webi Promotion to other server, Connect...

Re: insufficient privilege currency conversion to shared...

Re: Connect SAP Web Intelligence to SAP Datasphere analytic models using OAuth 2.0