I have a third party application that generates a dynamically created zip file in the following format (<FileName>.csv_2015-12-09_21-17-47.zip) I want a expression or task that will extract this file in the same location, but each time this file is generated it has a different timestamp. How can...
Okay...So by Default...my Dimtime dimension did not include the PeriodID in the dimension model. So after adding it I was able to rebuild the new Time Calculation dimension accordingly. So now I have added the MDX code as defined and modified to use my heirarchies and dimensions accordingly...
Yes, when building the Time Calculations dimension, I select PeriodID as the key column and PeriodID as the column containing the member name. Then saved and reprocessed the dimension. When trying to add it to the model through the "Dimension Usage" I set up a referenced relationship type...
I tried to step through the document referenced above and have a question implementing it. Firstly, when defining the dimension usage step, after selecting the intermediate dimension and the reference dimension attribute, the options for my intermediate dimension attribute does not allow me to...
I created it using the Add Business Intelligence using the time intelligence wizard. It then creates multiple measures and scripts under my date dimension. but then using the Year - Quarter - Calculations level now created in the date dimension..everything defaults to "NA" and I can see that in...
Can someone facilitate how to deploy this calculated measure? I have one created to display a sales value growth from a month over month, average, and six month average. Using the function it creates the script. but when displaying the value in the cube all values show as "NA" an I am unable to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.