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
- Can Someone explain the Purpose of the different Build Actions in VS 2008?
- How do I port code that contains #pragma optimize( "a" ) from VC++7 to VC++9?
- Compiler Error for unknown reasons (C++)
- x86 MUL Instruction from VS 2008/2010
- Duplicate characters when typing in VS 2022 .cs page
- Data not aligned correctly in Visual Studio if run in debugger
- Is there a format code shortcut for Visual Studio?
- Is there a way to drag & drop to copy files between two visual studio instances?
- Order of Using Directives in C# - Alphabetically
- Visual Studio 2008 - jump to line number shortcut
- What is Inline Frame in c++/VS?
- New tuple syntax not working in C# version 7
- "No tests found to run" Xunit test not detected in Test explorer, Visual Studio 2022
- How can I make control+click do a "Go To Definition"?
- Access ComboBox.SelectedItem from a different form
- Is there a quick way to navigate to the underlying object of a variable in Visual Studio?
- What is this Icon in the Visual Studio 2008 debugger strip?
- How to stop Visual Studio from adding IIS Express to launchsettings
- How to use MapStaticAssets if upgrading from .NET 8
- Why Doesn't the Visual Studio 2010 Debugger See static const Class Members?
- Visual Studio 2015 Ctrl + D (code duplication) not working (keyboard shortcut scheme issue with Resharper)
- How to disable warnings at solution level in .NET projects
- How to use Obfuscar in the publish process of .NET Applications
- Compile SFML with /MT flag in Visual Studio
- Getting a certificate error whenever i run any web app in visual studio 2022
- Cannot open source file gtest/gtest.h
- How do I generate a constructor from class fields using Visual Studio (and/or ReSharper)?
- VS 2022 errors ENC0020, ENC0021 even though code changes were made prior to starting debug session
- Visual Studio Docker Project outside Visual Studio gives Empty reply from server
- VS 2008 C++ build output?