TM1 Forum

Hi, Resurrecting an old post, I have a use case for this. When I store ODBC information in a cube, the ODBC password is not encrypted. I was thinking if I could set up a user in TM1 and set the password to be their same as the ODBC password, I could use this in the DatasourcePassword. Alas, all it d...

Hi, I saw a rule where for a DB to a cube, the dimension names had apostrophes around them, e.g. Instead of this: DB('Cube', !Version, !Year..); the rule had this: DB('Cube', !'Version', !'Year'..); I must admit it completely escaped me that you could do this, but I was wondering, is there any advan...

Hi,

we need to know more about the relationship between the account and acct_summary_Items dimensions.

For example, could you create a rollup in the account dimension where the parents are the acct_summary_Items and then reference that in the rule.

And then feed from the account attribute.

Maren

Hi,

Would have been good if this:

For some reason, it's not working for a few elements

was this:

For some reason, it's not working for a few versions!

But good that you told us the problem and managed to resolve it.

Maren

Hi,

any reason you can't do this via a process and incorporate it into your existing action button?

Maren

Hi,

The other thing to test, if you haven't already, is to first insert the new columns inside the existing ones, for example insert before the last column, and then if those columns calculate ok, move the last column to before the new columns.

Maren

Sorted by copying over

Hi, either of these should work, but there are lots of different ways: FILTER(TM1SUBSETALL([report_HDD_fiscalPeriodByDay]) , [report_HDD_fiscalPeriodByDay].CURRENTMEMBER.NAME = [CONTROL].([Control Parameters].[Current Month],[CONTROL_m].[S-Value])) + FILTER(TM1SUBSETALL([report_HDD_fiscalPeriodByDay...

Hi,

The TM1a.exe file has somehow been deleted from our production server.

I was just just wondering if I could simply copy the file from our Dev environment into production? Didn't want to do this before checking with the experts.

Maren

Hi George,

Apologies but there is no date dimension in the cube.

The date dimension is in a Staging cube and a TI process would populate the relevant Year, Period and Week based on a Date lookup cube, which would include the dates business, calendar year/period/week.

Maren

Hi George, I did think about that or using another rollup but the issue is that the value will be the intersection of the 3 different dimensions and the values are held at leaf level. So the same value, lets say £100, goes into Calendar Year 2024, Calendar Period 12, Calendar Week 52 and Business Ye...

Hi, We have a requirement to report off 2 different set of periods (Calendar and Business). This is at Year, Month and Week level. For example, 31/12/2024 falls into: Calendar Year 2024 Calendar Period 12 Calendar Week 52 Business Year 2025 Business Period 1 Business Week 01 The requirement is to re...

Hi, I am trying to use the CreateHierarchyByAttribute function in Planning Analytics and am receiving the following error: Error: Prolog procedure line (22): DIMENSIONHIERARCHYCREATE: Cannot create hierarchy "Code Region": dimension "Code" already has element names/aliases contai...

So when you said,

I basically went through all the steps outlined in Wim Gielis's blog post and the users still can't enter in data.

Basically meant, not really!

Hi Declan,

I see what you did there, absolute fricking genius! Works like a charm.

Maren

Hi Paul, thank you for the response. I don't think adding the child element will help because the issue occurs when the consolidation itself doesn't exist. The consolidations only get created the first time a user adds in a new employee. At the moment I am dealing with this via an attribute against ...

Hi, I am trying to write some MDX which will return a subset depending on who is logged in. For Admin users it should just return all elements. For Super Users it would also return all elements. For Planning users it should only return the elements they created, i.e. added to the dimension. The prob...

OMG, no more TM1forum after 2028! I think I might retire myself.

You guys have done a first class job, I don't think I could have done it without you!

Hi,

I guess the only other thing is to run Security Refresh in case you haven't.

Maren

The formula is subtraction, so DBRW()-DBRW() Well you said initially, I have a report in PAfE where I have DBRW() + DBRW() I guess this is going to be a minimum information problem! If Burnstripe's suggestion doesn't work you could try adding the measure dim to the TM1RPTITLE. Or say having the fir...