TM1 Forum

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?

Hi, The PAW is unavailable, try again in a few minutes message usually indicates that the containers are firing up, rather than they have stopped working. But anyway, this is my go to page when the containers are in a mess, and it also includes some useful recommendations. https://www.ibm.com/suppor...

Hi, Thank you for the responses, I created a process to delete the cube. I should add that this was on IBM cloud, so hopefully not anything to do with performance Modeler, but I do remember something about how it could create that dimension. Why an Admin would have done this remains a mystery! Maren

Hi,

Does anyone know how the dimensionsecurity cube can get created. I am seeing it in a model today, and it is causing access issues as it is just empty, and empty means no access.

More pertinent, is the best way to get rid of it to use CubeDestroy?

Maren

Hi, Thanks for clarifying. I did say try it out if only to narrow down the problem, wasn't suggesting IBM should do nothing about it. I will be honest v12 is not something I have had the pleasure yet, but good to know someone is going through the pain on my behalf! Hope IBM sort the issue out. Maren

Hi,

I would try replacing the STRTOMEMBER part of your MDX, so rather than looking at currentmember.PROPERTIES("dimname1attr") it looks at a mapping cube.

Even if you don't like the idea, if it works, you know it is an issue with the currentmember.PROPERTIES.

Maren

If you are creating this from a TI process, which you might have mentioned from the start, then you can check is SubsetAliasSet is being used.


Maren

Hi,

You are a bit light on information, for example, are we to assume that 2 - FPA is an alias?

If so, this could help

DESCENDANTS(
TM1FILTERBYPATTERN(TM1SUBSETALL([Project]) , "2 - FPA","Whatever the Alias is called")
, 2)

Maren

The Web Server (IBM Planning Analytics Spreadsheet Services) is optional. If you are going to publish all your reports either in PAW or PAFE then you don't need TM1Web. Don't you need IBM Planning Analytics Spreadsheet Services to run websheets in PAW? For example, if I want to change the proxy tim...

Hi, Thank you for the responses, very insightful. I can say for certain the STET isn't required in this cube. The reason the Costing % might be fed is so it can be copied in TI processes, my understanding is that if the cell is not fed then it will not show up in a TI data source, unless zero cells ...