public static VpaModel ImportVPAX(string filename)
{
var content = VpaxTools.ImportVpax(filename);
var view = new Dax.ViewModel.VpaModel(content.DaxModel);
return(view);
}
private static void ImportExport()
{
string filename = @"c:\temp\AdventureWorks.vpax";
string fileout = @"c:\temp\export.vpax";
var content = VpaxTools.ImportVpax(filename);
VpaxTools.ExportVpax(fileout, content.DaxModel, content.ViewVpa, content.TomDatabase);
}
static void GenericTest()
{
//
// Retrieve DAX model from database connection
//
// String connection for Power Pivot
// const string serverName = @"http://*****:*****@"localhost\tab19";
// const string databaseName = "Adventure Works";
// const string databaseName = "Adventure Works 2012 Tabular";
// const string databaseName = "EnterpriseBI";
const string serverName = "localhost:59700";
const string databaseName = "ea26c45e-2916-4df9-85b1-efed49126482";
const string pathOutput = @"c:\temp\";
Console.WriteLine("Getting model {0}:{1}", serverName, databaseName);
var database = Dax.Metadata.Extractor.TomExtractor.GetDatabase(serverName, databaseName);
var daxModel = Dax.Metadata.Extractor.TomExtractor.GetDaxModel(serverName, databaseName, "TestDaxModel", "0.2", true, 10);
DumpRelationships(daxModel);
//
// Test serialization of Dax.Model in JSON file
//
// ExportModelJSON(pathOutput, m);
Console.WriteLine("Exporting to VertiPaq Analyzer View");
//
// Create VertiPaq Analyzer views
//
Dax.ViewVpaExport.Model viewVpa = new Dax.ViewVpaExport.Model(daxModel);
// Save JSON file
// ExportJSON(pathOutput, export);
Console.WriteLine($" Table Count : {viewVpa.Tables.Count()}");
Console.WriteLine($" Column Count: {viewVpa.Columns.Count()}");
string filename = pathOutput + databaseName + ".vpax";
Console.WriteLine("Saving {0}...", filename);
// Save VPAX file
// old internal version ExportVPAX(filename, daxModel, export);
VpaxTools.ExportVpax(filename, daxModel, viewVpa, database);
Console.WriteLine("File saved.");
// ImportExport();
Console.WriteLine("=================");
Console.WriteLine($"Loading {filename}...");
// var content = VpaxTools.ImportVpax(filename);
// var view2 = new Dax.ViewVpaExport.Model(content.DaxModel);
Console.WriteLine($" Table Count : {viewVpa.Tables.Count()}");
Console.WriteLine($" Column Count: {viewVpa.Columns.Count()}");
}
static void Main(string[] args)
{
//
// Retrieve DAX model from database connection
//
// String connection for Power Pivot
// const string serverName = @"http://*****:*****@"localhost\tab17";
// const string databaseName = "AdventureWorks";
const string databaseName = "Adventure Works 2012 Tabular";
// const string serverName = "localhost:63041";
// const string databaseName = "4b071c24-b2e6-49b0-a3b6-93610cfe1d0c";
const string pathOutput = @"c:\temp\";
Console.WriteLine("Getting model {0}:{1}", serverName, databaseName);
var database = Dax.Metadata.Extractor.TomExtractor.GetDatabase(serverName, databaseName);
var daxModel = Dax.Metadata.Extractor.TomExtractor.GetDaxModel(serverName, databaseName, "TestDaxModel", "0.1");
//
// Test serialization of Dax.Model in JSON file
//
// ExportModelJSON(pathOutput, m);
Console.WriteLine("Exporting to VertiPaq Analyzer View");
//
// Create VertiPaq Analyzer views
//
Dax.ViewVpaExport.Model viewVpa = new Dax.ViewVpaExport.Model(daxModel);
// Save JSON file
// ExportJSON(pathOutput, export);
string filename = pathOutput + databaseName + ".vpax";
Console.WriteLine("Saving {0}...", filename);
// Save VPAX file
// old internal version ExportVPAX(filename, daxModel, export);
VpaxTools.ExportVpax(filename, daxModel, viewVpa, database);
Console.WriteLine("File saved.");
// ImportExport();
}
