TM1 Forum

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...

Hi John, Dynamic reports simple, is it April fools day! Can you share exactly how the DBRW looks, because as nuts as this sounds I had an issue where the DBRW did not work if I put a space between the + sign and the second DBRW, I had to do something like, =@DBRW(cube,dim1,dim2,measure1) +@DBRW(cube...

Hi Declan,

I didn't have the option of Format Manager when I right clicked but it is in the icon list at the top of the screen.
Following your advice by changing the row header format it now appears to work.

Many thanks.

Maren

Hi,

Does anyone know how to wrap the row dimension element names in PAW? For example if I have a long employee name I want to wrap it so I can reduce its length.

I have tried and failed to achieve this and believe I must be missing the obvious!

Maren

Hi,

I think I have sorted this by adding "'SET NOCOUNT ON;" to the SQL query.

Maren