Can I open multidimesional model in Visual studio from SAP BW Query?
I have installed Visual Studio 2017 with SSDT extension. There is a Query (on OLAP) in SAP BW. I can connect to this query using Analysis for Office from Excel to see the data from this query. This connection is made through Insert Data source using SAP logon and my credentials.
My question is - Can I open the Query in Visual Studio like a Project? I mean not just see the data without any relationships, but to see the table and design views? How can I import the Model into Visual Studio?
Thank you
You need Microsoft BW Connector installed which is a part of Microsoft® SQL Server® 2016 Feature Pack and also you need BI Developer Extensions for Visual Studio (SSDT) which you supposedly already have.
Just select SAP BW Source as a data source in Visual Studio and follow the instructions from this guide. Finally you should have something like this
- How to properly install additional C header files in VS 2022
- (Deep) comparison of an object to a reference in unit tests (C#)
- How can one disable the first autoselect in a VS datagridview?
- Can't add members to SSAS role through Visual Studio
- How to install Microsoft.ReportingServices.ReportViewerControl.WebForms NuGet package to a non SDK style project using PackageReferences?
- Can I run Git commands in Visual Studio?
- SqlCommand doesn't return result from the C# application (MS Access database)
- Shared AssemblyInfo for uniform versioning across the solution
- is it possible to link an exe file as a lib file to another project?
- VS2015 "no symbols loaded for this document" for .lib file
- Can you publish a new standalone Angular project (esproj) directly from VS2022 to Azure?
- Unresolved external symbol in library in C++
- Embedding thread names in Windows minidump files
- I can no longer debug Office Add-in from Visual Studio
- Azure Active Directory passing empty GUID for tenantId with default template
- How to print values of multiple variables in one Console.WriteLine() statement?
- C2664 cannot convert argument from 'initializer list'
- Custom NuGet feed with invalid certificate
- Smart way to add same library/include paths to different projects in Visual Studio
- VS Code extension with webpack and link to node_modules
- Adding dynamic tabs to a tab control
- how to copy paste a WPF Window (clone) and not have errors
- Programmatically retrieve version of an installed application
- Visual Studio 2022 can't connect to a project due to bad filters
- Running two projects at once in Visual Studio
- Remove TFS Connection From Visual Studio 2019
- Aspire sample app - hidden css Web.styles.css?
- .NET solution - many projects vs one project
- How to fix "the setup for this installation of Visual Studio is not complete"
- Must delete massive inadvertent checkin from remote git repo