TM1 Forum

Sounds complex for my novice skills but I will give it a try. Thanks for the tip.

This is great stuff and I got it to work. However, currently I have 275+ variables I need to create. These variables may change and/or expand to 300+ in the future. Is there an automated way to create a variable within the process? I have set everything up in Excel as to the naming of the variable, ...

This worked like a charm. Thanks for the help!

Hi Alan- Thanks for the response. Here are my responses: (a) - There are several rules-calculated values. (b) - No, I close all other workbooks and just open the one I want calculated. (c) - Not sure what this refers to...can you point me in the right direction? (d) - No DBRA formulas, only sliced D...

Hi- I am having a similar recalculation issue. When I open a DBRW linked file, sometimes the formulas will calculate instantaneously and pull from the cube, but often times, Excel just hangs. I am not pulling a lot of data - just a few columns worth. I end up having to close out Excel, re-log into t...

Create an attribute on the product dimension called 'Tax Rate' for instance.

I think I was able to do this.

Apply the respective tax rates to the parents such as cars = .25, vans = .27 etc.

Not sure what this means. Where/how do I apply the tax rate?

Thanks.

Hi- I searched high and low and scoured the internet, but couldn't find an answer... I have the following dimensions: 1) Period, 2) Product, and 3) BusinessUnit I wanted to have a rule apply a different tax rate to different product rollups. My product rollups are as such: Product Cars Car 1, Car 2,...

This worked! Thanks for the help!

Hi- I am trying to export the YTD results from a cube with Periods defined as "2018-01", "2018-02", etc. with a input from the user of the Year desired. For example, the user would input "2018", and the export would be for all months of 2018. As a part of my TI code, I ...