About charles_ditrani3

charles_ditrani3 · 03-30-2022

I have a simple query in Data Builder New SQL View (using SQLScript (Table Function) as Language): return select distinct first_value(lead_id) over (partition by converted_contact_id order by converted_date asc) AS L_id from Lead; This code retur...

charles_ditrani3 · 03-11-2022

I have a SQL Server table; if I replicate it to Data Warehouse Cloud, how is it stored (HANA, SQL, other)?

charles_ditrani3 · 10-15-2018

AWS has AWS Directory Service for Microsoft Active Directory. Can SAP BI 4.2 be configured to use it instead of the on-premise AD Domain? Still in the early stages of planning so I haven't actually tried it, but any best practices, tips, insights or ...

charles_ditrani3 · 03-30-2018

I'd like to restrict the set of objects in a universe that a particular user group can see, so I created a Business Layer View with those objects. How do I set security so the group can only see that Business Layer View?

charles_ditrani3 · 02-26-2018

I've got DEV and UAT SAP BI 4.2 SP3 environments that were created as copies of PROD. In the monitoring app of the UAT CMC, I see watches for some of the PROD servers; for example, bobjprod.CrystalReportsProcessingServer Watch. I can't delete this wa...

charles_ditrani3 · 04-01-2022

Thanks for the replies; I found a reference in the roadmap for Q2 2022 - "Enable the SQL editor to support SQL window function for scripting"

charles_ditrani3 · 10-16-2018

Great! That's exactly what I needed. Thanks, Tim!

charles_ditrani3 · 10-15-2018

Yes, I've read those. Great overview from a high-level perspective, with links to several other resources but I didn't see anything specific to using the AWS AD service. I assume it needs all the artifacts corresponding to an on-premise BI installati...

charles_ditrani3 · 03-30-2018

Great, Amit - that blog was exactly what I needed. It showed the workflow that I was missing.

charles_ditrani3 · 02-27-2018

Thanks, Jawahar - that worked!

User Statistics

User Activity

How to resolve "sql syntax error" in DWC?

How is replicated data stored in DWC?

Best Practice for SAP BI 4.2 on AWS Authentication using AD?

SAP BI 4.2 SP3: How to set Security on Business Layer View?

How to Delete Watches in SAP BI 4.2 SP3

Re: How to resolve "sql syntax error" in DWC?

Re: Best Practice for SAP BI 4.2 on AWS Authentication using AD?

Re: Best Practice for SAP BI 4.2 on AWS Authentication using AD?

Re: SAP BI 4.2 SP3: How to set Security on Business Layer View?

Re: How to Delete Watches in SAP BI 4.2 SP3