Filtering the cube
Hi community,
I'm in a proyect that I have to load data that cames from 3 different sources and one of these sorces is a csv file that contain the name of a switch and the name of a port. My cube have also this information, but I have to show only the values that match with this information. I'm trying to filter the cube through this method below, the problem was the result of the method is not only a value, it is an array with many values and I must use the IN operator and not this "&" symbol. I wanted to know if it's possible or not?
Result of : ‘acc23-mqui2.redip.clGi1/17’,’acc01-mqui2.redip.clGi1/17’,’acc01-mqui2.redip.clGi1/39’,’acc01-mqui2.redip.clGi1/39’,’acc22-mqui2.redip.clGi1/43’.
Another option is to user the Restriction inside the cube, in Architect module. (I have a dimension called “DatoSplunk” that brings these array. )
ClassMethod %OnGetFilterSpec() As %String [ Final ]
{
Set tEquipo = ##class(Teleducto.DS.Utils).BuscaEquipoPuerta()
if tEquipo '= ""
{
Set tFilter = "[EquipoPuerta].[H1].[EquipoPuerta].&["_tEquipo_"]"
}
else
{
set tFilter = ""
}
Quit tFilter
}
Thanks all.