TM1 Forum

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

Hi all, I have a TI process which uses an ODBC data source. The SQL is constructed on the prolog. If I use the following code in the Where Clause the process runs fine in a few seconds without any issues: 'AND [ElementName] = ' | CHAR(39) | 'Pension Salary Sacrifice' | CHAR(39) | ' ' | However, if I...

Hi,

I don't believe the Security Overlay affects Admin users, are you an admin user? Have you tested a non admin account?

Maren

Hi,

never used the CreateViewByMDX function before, so hopefully someone with more experience with that will be ale to help you out. I still prefer viewcreate.

But just to confirm, this is not a consolidated element:

mdxProcessSalesMonthYTD

Maren

Hi, Your screenshots confuse me as it appears the hierarchies have been created, I am also having trouble working out which is the expected and which is the actual outcome. Also, I don't see any reference to inserting a consolidated element in your code or anywhere that adds an element to a parent? ...

Maybe someone at IBM has a real OCD about symmetry?