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:53382";
const string databaseName = "1d83feec-d09a-4766-980e-757adb5690ea";
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");
//
// 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 GenericTest()
{
//
// Retrieve DAX model from database connection
//
// String connection for Power Pivot
// const string serverName = @"http://*****:*****@"localhost\tab19";
const string databaseName = "Adventure Works Internet Sales";
// const string databaseName = "Adventure Works 2012 Tabular";
// const string databaseName = "EnterpriseBI";
//const string serverName = "localhost:51948";
//const string databaseName = "e444a82b-ee82-46b2-9982-15605c037a51";
//const string serverName = @"localhost\ctp22";
//const string databaseName = "Contoso Base";
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);
Console.WriteLine(database.CompatibilityMode);
//DumpReferencedColumns(daxModel);
//DumpReferencedMeasures(daxModel);
// 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()}");
Console.WriteLine($" Relationships Count: {viewVpa.Relationships.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);
viewVpa = new Dax.ViewVpaExport.Model(content.DaxModel);
Console.WriteLine($" Table Count : {viewVpa.Tables.Count()}");
Console.WriteLine($" Table Count : {viewVpa.Tables.Count()}");
Console.WriteLine($" Column Count: {viewVpa.Columns.Count()}");
Console.WriteLine($" Relationships Count: {viewVpa.Relationships.Count()}");
}
