SeveredementiA's questions

I have a doubt in some concepts in the subject of data warehouse , if someone could clarify it for me I would be very grateful.

To explain my doubt, I will present the following example. There is the following dimensional scheme :

Taking into account that there are measures of the Additive, Semi-Additive and Non-Additive type .

How do you insert the average data into the fact table since an average is a coarser-grained measure? (Different granularity).

First of all, Thanks.

I am new to BluePrism. I have a file archivo.xlsxand I need to move it to another folder and change its name. The name must be in the format archivo_ddmm.xlsx("ddmm" Current day and month).

I have a doubt in wolfram mathematica. What happens is that I have an array of data and I can generate a espectrograma, what I need is to generate this same spectrogram in 3 dimensions,

2D spectrogram

3D spectrogram (what I want to obtain)

What I want is to achieve something like in the following image

I have achieved it with files .WAVbut not with an excel column with data, which I import into mathematica, I only managed to apply filters and do the spectrograma2D. If someone could give me some help I would appreciate it. Thank you very much.

Edit (I'll add what I have regarding the doubt)

I am using the code that is in the following link, but I think I do not understand the input parameters for the function well, I cannot get it to work for the .csv file . It is probable that I am doing everything wrong and this is not the function that I should use, I have also tried with ListPointPlot3D without results (I can only graph the spectrogram in 2D), but here they import a .WAV file

https://mathematica.stackexchange.com/questions/4017/computing-and-plotting-a-spectrogram-in-mathematica

Attached is the link of the noise.scv file (file of values ​​separated by commas) which is the one I need to graph

https://mega.nz/#!P912VDIT!cRuug34tTVqFO41bc4hhepLfxk4jV5mYCJjwfeTYvLI

And finally the lines of code to import the file to Wolfram

datosExcel = Import["C:\\ruta_del_archivo.csv"]
datosExcel = datosExcel[[All, 1]]