What’s New: Data Wrangling and Modeling in SAP Analytics Cloud #ASUG Webcast recap
You can register for the replay : BI: What’s New: Data Wrangling and Modeling in SAP Analytics Cloud
Join us for these upcoming webcasts:
February 19 BI: SAP Analytics Cloud for BW Customers
February 21 BI: What’s new in SAP BI4.2 SP7
The legal disclaimer applies that things in the future are subject to change.
Data Wrangling – upload data from different data sources, resolve quality issues or change layout of data
Unpivot columns to rows will be released in Q2/2019
As described by SAP:
It allows you to transpose columns into rows when you are preparing your data in the modeler. The new table format can then be used to either import data or create a new model. It is important to note that you can only perform one unpivot transformation per session on any given dataset. Another thing to note is that the table resulting from the unpivot transformation cannot contain more than 50 million cells
Data import road map is above
Q1 can rebuild models
Q2 – connectivity to multiple SAC agents
Q2 – IBP import, CRM data sources, remove data import limitation (today only 800K rows)
Q2 – data geo location
Future – remove feature parity between live and import data
Q2 is planned
Able to create new models if using Data Model
Use Data Hub to create dataset and use that in SAC
Working to rebuild experience, UI, new functionality
Modeling is faster, efficient
See all dimensions, accounts, sort them
Improve side bar
Moving models into file repository; gives you way to organize models
This is for planning; multiple time dimensions
Q2 has new enhanced modeling experience, undo and redo in modeler, models in file repository
Look for updates at sapanalytics.cloud home page
Future direction – enabling more modeling workflows on live data connections – may take some time
Multi source models – enabling you to combine data sources into 1 model
Question & Answer
Q:can you do this with any data source?
A: new modeler for imported data sources
Q: i was asking about unpivot
A: any data – import only
Q: Is this included as part of SAP Cloud Analytics or is this a separate license?
A: part of core (BI) – planning is separate license
Q: When would be the models availabile in Files? currently we see this is a flaw from security and access point of view..
Q: Can you tell more details about the “Support for Undo/Redo” function? Can I undo a dimension after I created it and saved the model? Thank you.
A: when save, undo redo is gone
Q: How does this fit with regards to Agile Data Preparation? Is it planned to have feature parity with Agile Data Prepariation?
A: know what ADP is capable – not rebuild ADP
Q: Can rights & access be mapped to AD groups like you can do in the BIP CMC?
A: You can create a team, and those teams can be mapped AD as long as using SAML 2 protocol
Q: I don’t if that’s asked but what is the security with models in files. Can we give or restrict Access to some models?
A: Yes you can use folders first; saw on his screen