Get Free Trial

Slice Object – expand info

Answered
Marius Hulduban asked on May 6, 2021

Hi,
we tring to develop a custom feature for expand certain cells. For example expand all children from one cell.
We execute a custom MDX for retrieve data for build “slice.expand object”.
 
We have some problem with numeric data type, for exaple (investigating report object after manualy expand cells) the expand object is:

...
{
"tuple":[
"[02 - Selezione Azienda].[Azienda].&[SS1831-AZDEMO SRL]",
"[04 - Selezione Dipendente Valori Ultima Mensilità].[Nominativo].&[000026 - COGNOME000026 NOME000026]",
"[04 - Selezione Dipendente Valori Ultima Mensilità].[Data Assunzione].&[2011-10-01T00:00:00]",
"[01 - Selezione Periodo].[Anno].&[2020]",
"[04 - Selezione Dipendente Valori Ultima Mensilità].[Età].&[4.4E1]",
"[05 - Selezione Attributi Dipendente Mensili].[Perc Invalidita].&[0]",
"[05 - Selezione Attributi Dipendente Mensili].[Perc Part- Time].&[1.E2]"
]
},
{
"tuple":[
"[02 - Selezione Azienda].[Azienda].&[SS1831-AZDEMO SRL]",
"[04 - Selezione Dipendente Valori Ultima Mensilità].[Nominativo].&[000026 - COGNOME000026 NOME000026]",
"[04 - Selezione Dipendente Valori Ultima Mensilità].[Data Assunzione].&[2011-10-01T00:00:00]",
"[01 - Selezione Periodo].[Anno].&[2020]",
"[04 - Selezione Dipendente Valori Ultima Mensilità].[Età].&[4.4E1]",
"[05 - Selezione Attributi Dipendente Mensili].[Perc Invalidita].&[0]",
"[05 - Selezione Attributi Dipendente Mensili].[Perc Part- Time].&[1.E2]",
"[04 - Selezione Dipendente Valori Ultima Mensilità].[Anzianità].&[9.]"
]
}
...

All the dimension (Anno, Età, Perc Invalidita, Perc Part- Time, Anzianità) in the cube are “Numeric Type”
Why for some one are using “scentific notation” (Età, Perc Part- Time, Anzianità, …) insted Anno is “string like”.
 
There is some particular logic to apply?
 
Best Regards

4 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 7, 2021

Hi Marius,
 
Thank you for posting your question.
 
We’ve investigated this behavior with the cube dump you sent us back in 2020. 
 
We could replicate the same behavior on our side and realized that it is expected since this is what the hierarchy member unique names look like in your cube data – Flexmonster merely uses them as is.
 
To verify this, view the dimension member in SQL Server Management Studio in Design Mode as a raw query (see the attached screenshot for illustration).  
 
Please let us know if this helps.
 
Bets regards,
Mykhailo

Attachments:
ssms_format.png

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 13, 2021

Hi Marius,
 
Hope you’re doing well!
 
We were wondering if you’ve found our previous response helpful. Is there still anything we can help you with?
 
We’d be happy to hear your feedback.
 
Best regards,
Mykhailo

Public
Marius Hulduban May 13, 2021

Hi Mykhailo,
yes, i can confirm it was our mistake. 
“Anno” dimension was declared as INTEGER, but “Età” dimension was DECIMAL (directly in the CUBE).
 
Best regards
 

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 13, 2021

Marius,
 
Thank you for the update, glad to hear you’ve found a solution!
 
As always, feel free to reach out in case any other questions appear.
 
Mykhailo

Please login or Register to Submit Answer