A table alias is a copy of the existing table with a different name, which can be created using Strategy Server SDK as shown below,
… After successfully connecting to the Intelligence Server - Project and creating a valid session…
Dim myTable As IDSSTable
'Find the table for which you would want to create an alias
Set myTable = objSource.FindObject("02E5E05A42AECB56D42014962977C875", DssTypeTable)
'Search for the folder where you would like to save the alias
Set objFolder = objSource.FindObject("8D678D5011D3E4981000E787EC6DE8A4", DssTypeFolder)
Set objInfo = myTable.Info
'Make a copy of the table in the specified folder with the given 'name
Dim newTable As IDSSTable
Set newTable = objInfo.Copy(objFolder, "MY_LU_YEAR1")
'Clear the properties for the table alias
newTable.AttributeInfos.Clear
newTable.FactInfos.Clear
newTable.Size = 0
newTable.TableKey.Clear
newTable.FactGroups.Clear
newTable.PartitionTables.Clear
newTable.PartitionLevel.Clear
newTable.SecondaryDBRoles.Clear
'Save the alias table
objSource.SaveObject objInfo1, , DssSourceSaveOverwrite
'Add the alias table to the schema tables collection
Set mySchema = objSource.Schema
mySchema.Tables.Add newTable
mySchema.Info.Save
Code Customization:
WARNING:
This customization is provided as a convenience to Strategy users and is only directly applicable to the version stated. While this code may apply to other releases directly, Strategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. In the event of a code change in future builds, Strategy Technical Support makes no guarantee that an updated version of this particular customization will be provided. In the event of a code change in future builds, Strategy may not be able to provide additional code on this matter even though this customization is provided at this time for this specific build. For enhancements to this customization or to incorporate similar functionality into other versions, contact your Account Executive to inquire about Strategy Consulting assistance.
