TM1 Forum

Thanks Tomok for your tips, I will do that.
W

Dear all TM1 experts: I have lots of elements in various dimensions which I am sure not been used at all, which I would like to delete. I also want to know which elements from what dimension been used in what cubes, so that I can do some clean ups (ie, delete those not been used at all elements and ...

Thank you very much everyone.

I will have look and trying it.

Very much appreciated all your supports.

W

As asked before, do you need 1 YTD (for today or yesterday for example), or each day's YTD ? Hi Wim, thanks for your reply. I suppose I just need 1 YTD, so eg, if user open an report today, the YTD will adding up from 1st July 2019 to 22 Jan 2020, and if user open the report tomorrow, then, the YTD...

Create YTD consol for each day e.g 20200120 YTD with a TI process. You could have a separate Reporting Cube with Period YTD dimension (just as an example). Rule will be too inefficient, you will probably end up blowing the feeder stack too with deep recursion Thanks all, Hi EvgenyT, as I am quite n...

Hi All TM1 Experts I have a question regarding how to do a dynamic YTD calculation on a continuous time dimension (not a Discrete Time Dimension). Below are the details. So, I have a daily labour hour cube, where using a continuous time dimension (ie, 01/07/2019, 02/07/2019, 03/07/2019 .... etc (dd/...

Hi All: Have a question regarding to the data security. We have a Financial Reporting cube, made up by dimension: Version (ie, actual, budget, forecast) ,Year, Month, Entities, GLAccount and GLMeasure. GLMeasure dimension has measurement like: Balance, Opening Balance, Closing Balance, etc. We uploa...

Hi:

Thank you guys for the help.

Great tips and helps.

Very much appreciated.

Best Regards
W

Hi All: I am creating a dynamic subset on my time dimension by MDX. SubsetCreatebyMDX('MDXSet','{intersect( Filter( TM1SubsetAll( [ContinuousTime] ), [ContinuousTime].[PreviousNumber] >= '|vEndNo|' ), Filter( TM1SubsetAll( [ContinuousTime] ), [ContinuousTime].[PreviousNumber] <= '|vStartNo|' ) ) } '...

Thanks guys for help.

In my case, what should be the MDX code exactly? Not very familiar with MDX query, could you guys kindly help.

Thanks
W

Hi all: I have a question regarding how to create a dynamic time dimension subset ( I am using continuous time dimension type ). Little back ground: I need to load rolling 21 days data into a cube using TI process on daily scheduled basis. (ie, delete old one, and load again by fresh downloaded csv)...

Hi all: Just a quick and short question below. Is there anyway to trigger a Macro or Power Query in Excel in TM1 web? I have some excel spreadsheets, which in a combination of TM1 excel formulas and Macros and Excel Power Queries. Once I upload the excel to TM1 web ( in TM1 -> Application -> Report ...

Thanks Orlando, that works.

Very much appreciated.

W

Hi all: I have an occupancy cube to tracking daily occupancy with users putting comments everyday in the cell level. Then, I have built a replicate of the occupancy cube with better time dimension ( rest dimension the same as the old one). I have migrated data from old cube to new cube via TI proces...

Thanks Orlando, thats help a lot.

W

Hi Orlando: Thanks for your help. The below is my dimension screen shot. As you can see, I am at the moment, manually adding the year number and month number to the 2 newly add attributes of the dimension on day level. Just wandering , if there is a fast way / automatic way to do this process, maybe...

Hi Orlando: Thanks for your help. I did small sample test, and it works. But that bring me another question. How do I mass edit my continuous time dimension attributes? When I built the continuous time dimension, I didn't populate the Year and Month attributes, and this dimension been used in so man...

Hi All: I have a question regarding to the 2 different types of time dimension (continuous vs discrete) I have an occupancy cube using continuous time dimension on daily level to record the daily occupancy number. Continuous time dimension has 4 levels, Year-Month-Week-Day. Then, I have budget cube ...

Hi Tomok:

Thanks for your help, I used the rules, your second point.

Its works. Thanks so much.

W

Hi All: I am working for a hotel business, we keep tracking the daily occupancy rate , which is occupancy / available beds (on daily level). I have an occupancy cube, which made up by Time, Centers and Occupancy_M dimensions. In Occupancy_M dimension, amount other measurements, I have "occupied...