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 do you auto format code in Visual Studio?
- Nuget resource change from https to http
- (Azure DevOps Testplans) Is it possible to associate an automated Test to a testcase without Visual Studio?
- Is there a way to force msbuild to only build x64?
- Unable to find suitable Visual Studio toolchain. Please run `flutter doctor` for more details
- How to compile x64 code with Visual Studio in command line?
- Visual studio compiler directory in windows
- 2 Functions in 1 main program(Visual Studio 2013)
- Selecting a "block" of text in Visual Studio
- Node.js - Do I really need Visual Studio ? And Python 2.X or 3.X?
- Differences with IDE/compilers array handling
- Visual Studio's iOS Simulator for Windows won't launch, stuck in connecting loop for Xamarin or MAUI
- project can't be opened, visual studio crashing
- MSHTML reference in a Visual Studio 2022 on Windows 11
- how to copy paste a WPF Window (clone) and not have errors
- What is the shortcut to skip all break-points in VS?
- VS2019 : resource file error: Neutral (Default) (unknown sub-lang: 0x8)
- How to make intellisense popups exclude #include folders from symbol popups?
- The program does not compile when I run it in VS2010
- How do I make the debug build faster for Android in .NET MAUI?
- Failing to build sharpsnmplib samples in VS2019 could not load file or assembly System.Text.Json
- How to fix Visual Studio 2022 Warning CA1416 "Call site reachable by all platforms" but "only supported on: 'windows'"?
- Could not find file 'C:\SomePath\Oracle.DataAccess.Common.Configuration.Section.xsd' when connecting to Oracle server
- Can Visual Studio use an .editorconfig not in the directory hierarchy?
- Can I programmatically attach a running .NET 6 process to a running instance of Visual Studio debugger?
- How to set BuildInParallel="false" in a .NET SDK style .csproj?
- Visual Studio 2022: AWS Toolkit broken, won't let me reinstall
- How to export a procedure outside designer in C# / VS Community
- How to quickly organize functions in source code (c#) to order by alphabetical order?
- How to see the structure of a file