TM1 Forum

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

Hi Declan, Thank you for the feedback. My apologies and I should have made this clear, the DB is to another cube, so that is required. What I meant is, does the rule need to to have the IF for the DB, does it really need to ask whether the value is 0? Rather wouldn't it be better to remove the if fo...

Hi, I came across the following rule and I felt that it was inefficient but just wanted to check here in case I missed something. The rule is as follows: [ 'Costing %'] =N: IF( [ 'Forecast Flag' ] = 1 & DB('Appointment data',Version,Year,Cost Centre,Employee,Position,'Costing %') <> 0, DB('Appoi...

Hi Wim, MDX is: WITH MEMBER [Version].[Version].[UserVersionA] AS STRTOMEMBER("[Version].[Version].[" + [User Selection].( STRTOMEMBER("[}Clients].[" + UserName + "]"), [User Selection Measures].[Version Compare A]) + "]") MEMBER [Version].[Version].[UserVersi...

Hi George, Appreciate you testing this. I followed your idea and it worked up to a point. The MDX didn't error and the MDX editor didn't remove code, so when I opened the MDX back up after closing, it looked the same. However, a couple of issues arose. First, nothing was being shown in the cube view...

Hi George, It doesn't appear to work, I tried this: WITH MEMBER [Version].[Version].[UserVersion] AS STRTOMEMBER("[}Clients].[" + USERNAME + "]").PROPERTIES("PAW Version Compare A") MEMBER [Version].[Version].[Version Variance] AS STRTOMEMBER("[Version].[Version].[...

Hi George, thank you for the reply. I am not sure I follow your advice, how do I get the value of TestVersionA without using this mdx, STRTOMEMBER("[Version].[Version].[" + STRTOMEMBER("[}Clients].[" + USERNAME + "]").PROPERTIES("TestVersionA") + "]"...

Hi, I want a a view which shows Version A - Version B, but version a and b are based on user selections. I am having trouble making the MDX view dynamic. The following does not work, it throws a MDX syntax error WITH MEMBER [Version].[Version].[Version Variance] AS STRTOMEMBER("[Version].[Versi...