on 03-21-2017 3:11 AM
Hello.
I use sap net connector and have some issue.
It's my code for executing mdx.
IRfcFunction fn = dest.Repository.CreateFunction("BAPI_MDDATASET_CREATE_OBJECT");
var queryTable = fn.GetTable("COMMAND_TEXT");
queryTable.Append();
queryTable.CurrentRow.SetValue("LINE", "SELECT ");
queryTable.Append();
queryTable.CurrentRow.SetValue("LINE", "[Measures].[0COST] ON COLUMNS, ");
queryTable.Append();
queryTable.CurrentRow.SetValue("LINE", "[0SALESORG].[3091] ON ROWS ");
queryTable.Append();
queryTable.CurrentRow.SetValue("LINE", "FROM [$CA_SD_02M] ");
fn.Invoke(dest);
var datasetId = fn.GetString("DATASETID");
IRfcFunction selectData = dest.Repository.CreateFunction("BAPI_MDDATASET_SELECT_DATA");
selectData.SetValue("DATASETID", datasetId);
selectData.Invoke(dest);
var returnedValue = selectData.GetStructure("RETURN");
if (returnedValue.GetString("TYPE") == "E")
{
Console.WriteLine("message: " + returnedValue.GetString("MESSAGE"));
Console.WriteLine("message v1: " + returnedValue.GetString("MESSAGE_V1"));
Console.WriteLine("message v1: " + returnedValue.GetString("MESSAGE_V2"));
Console.WriteLine("message v1: " + returnedValue.GetString("MESSAGE_V3"));
Console.WriteLine("message v1: " + returnedValue.GetString("MESSAGE_V4"));
}
it shows follow, without any details:
message: An exception was raised.
message v1: An exception was raised.
message v1:
message v1:
message v1:
I tested this query throw oledb for olap (mdrmsap), it works.
Any suggestion?
Solved.
Need to use
RfcSessionManager.BeginContext(dest)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.