About ScriptStoryDude

ScriptStoryDude · ‎04-09-2021

All - I am using time dimension in one of my modules. The default behavior of the Anaplan puts the time dimension in a format Jan 20, Feb 20 etc. However, due to data integration capability I have a specific requirement that I want to display months in format only Jan Feb etc. The year has to be different line. Below is an example what I am trying to accomplish. Any pointers will be helpful FROM Jan 21 Feb 21 Mar 21 Apr 21 100 200 200 250 DESIRED RESULT FY 21 FY 21 FY 21 FY 21 Jan Feb Mar Apr

ScriptStoryDude · ‎04-06-2021

@rob_marshall Appreciate your quick reply. Your solution works. I really wish there is some way to use properties. We are un-necessary creating additional dimensions where there is no need.

ScriptStoryDude · ‎04-06-2021

I am intending to display the properties of the dimension in a grid along with the dimension. If I add properties as line item then each line item is repeated across all the dimension elements, as the properties are tied to dimension members and they should not be repeating across dimensions. Below is the screen shot.. In this example my line item should be only amount and somehow I should be in position to display the dimension properties along with dimension. Happy to be on call as well. Need assistance. Dimension (X) Dimension(X) Property 1 Dimension (X) Proprtery 2 Jan Feb Mar 10050111001 CC_10050 Amount_USD Amount 100,000 100,000 100,000 10100111002 CC_10100 Amount_USD Amount 0 0 0 10050112006 CC_10050 Amount_USD Amount 500 500 500 10050211001 CC_10050 Amount_USD Amount 200,000 200,000 200,000

ScriptStoryDude · ‎03-11-2021

Team - I want to restrict the users to see only those items in the drop down to which that user has an access. For example, in the screenshot, I want to restrict the users to certain location.. and not every location.. selective access works great when the list is a dimension.. but not able to replicate the behavior when the list is a dropdown. Any pointers would be great. In this if I have access to only two items say Kyiv or Lyiv, then I should not see others.

ScriptStoryDude · ‎03-10-2021

Hey, did you get answer to your question. If yes, I will appreciate if you can share answer. I need similar functionality

ScriptStoryDude · ‎01-28-2021

Team - Currently working on FP&A model and one of the tasks was to copy and archive the model. I was wondering what typical scenarios drive the need for copying and archiving the model on frequent basis. Per my understanding the only need is to have a space limitation. I will appreciate some practical examples.

ScriptStoryDude · ‎08-01-2020

We have a problem to build and import the data from GCP bigquery. It need to be automated. I will appreciate the approach and if possible some sample code (written in python etc) to get the data from bigquery into anaplan datahub

ScriptStoryDude · ‎02-20-2020

In my current module which is dimensionalized by a numbered list I added additional 4 line items .. and I have a csv file based on which I want to update my current module. However, the dimension is a numbered list and display name has a logic to it. I have lot of other keys which can be unique to update the data, however, I have a feeling that without creating a common dimension, I will not be able to update. For example Dimension - Product (# numbered list product id + Effective date) Added 3 more attributes to the module.. color, and shape In my csv file, I have product id and product name which can make it unique but I am struggling to update the right attributes... Any help would be appreciable.

ScriptStoryDude · ‎02-18-2020

I guess, No. In your example, in the drop down for chosing Product A, against Chocolates, Nutzo bar should not be visible in the drop down ..

ScriptStoryDude · ‎02-18-2020

I have one dimension "Employee" and want to assign two products A and B. Product A and Product B are two line items formatted as Product List. It is perfectly fine if employee is assigned the first product however, when the employee is assigned product B, then product A should not be visible in the dropdown as the employee has already been assigned. Employee Product A Product B John Screws Nuts When John is being assigned Nuts then Screws should not be visible in the drop down. Seems like a simple situation but I am struggling to make the logic.

About ScriptStoryDude

Changing the labels of Time Dimension

Re: Display Dimension Properties along with Dimens...

Display Dimension Properties along with Dimension

Selective Down Selection - Selective Access

Re: Filter using Selective Access on Line Item Spe...

Copy and Archive Model

Importing data from big query

Update the Data in Current Module

Re: Dependent dropdown

Dependent dropdown

Selective Down Selection - Selective Access

Selective Down Selection - Selective Access

Selective Down Selection - Selective Access

Re: Display Dimension Properties along with Dimens...

Re: Selective Down Selection - Selective Access

Re: Editing of Dashboard

Converting data between line items with different ...

IF NaN Formula