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
- Visual Studio not finding my Azure subscriptions
- Why are the C# pre-build and post-build events not called if I import a custom target with my own build target in it?
- Visual Studio 2022: Increasing font of the app
- _ITERATOR_DEBUG_LEVEL error in visual studio
- How can i enable debug in android project properties (Xamarin Android)
- Visual Studio XML summary comment on single line
- MAUI project, cannot add a new Page
- Where is WindowsSDK_IncludePath defined?
- Get Visual Studio to run a T4 Template on every build
- New tuple syntax not working in C# version 7
- Unable to start program - Access is denied error in Visual Studio
- Low level mouse hook - mouse freeze on breakpoint
- Cannot see .csproj files in Visual Studio 2022 Solution Explorer
- C# - Compiling finished application / Using a file from inside the application?
- Conditional like: if application started from IDE then (do this) else (do nothing)
- Is it possible to write code that will cause long compile times?
- 401 - Unauthorized: Access is denied due to invalid credentials when Trying to access the TFS API by postamn
- Should I select : This is a full trust application
- How to uncomment multiple lines of code in Visual Studio
- Calling a command containing path with whitespaces using target 'Exec' in *.csproj files
- Questions about advanced compiler settings in visual studio Express 2008 express edition
- Statically linked application - invalid or corrupt dll
- Nuget connection attempt failed "Unable to load the service index for source"
- How to get data from a nested json in c#
- Intellisense doesn't show comments
- How to change test run timeout?
- Why can't I run the bower update command in Package Manager Console
- Error C2491 on C source with Visual studio 8
- How to compile this C# code into a DLL?
- Is there anyway to launch multiple Visual Studio projects, all in the same solution, for debugging, from powershell?