Shai Ben Ami's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: How to get export of Excel file which is getting used in the report.
Hi, In case your Data Model is based on an excel file, all you need to do is: 1. Open the model files 2. Go to the data flow 3. Click on the excel node 4.…
- Shai_Ben_Ami
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Optimizing a Star Schema Data Model
Hello, In the Data Modeling tool we have 2 different ways to add indexes: 1. Use the Auto Indexing ribbon button to let pyramid create the indexes automatically. 2.…
- Shai_Ben_Ami
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Using Variables with strings in Master flow
Hello Niko, When you use an expression then you need to threat the rest of the body as string, and concate it with the variable, and if you want to use quotes then you need to escape them with…
- Shai_Ben_Ami
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Date slicers- show months in chronological order
@Sophie durrant when you click on the Time Int node, in the property pane you can select and unselect the relevant column that will be added to the table.
- Shai_Ben_Ami
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Date slicers- show months in chronological order
@Sophie durrant if you want all the columns that I have then add Time Int node in the ETL
- Shai_Ben_Ami
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Date slicers- show months in chronological order
@Sophie durrant The "Time Intelligence" node is used inside our ETL to calculate and produce various date-time values (stored in new columns) based on a source date-time column.…
- Shai_Ben_Ami
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Date slicers- show months in chronological order
@Sophie durrant You should leave the column as Date. there is no need to change it to string for setting a format. The right way to format a date column is described in the picture below.…
- Shai_Ben_Ami
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Date slicers- show months in chronological order
Hi Sophie, We didn't change anything related to the time intelligence column ordering. Could you please open the Model file and follow the steps described in the picture below?…
- Shai_Ben_Ami
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: how to create nest folder view in configuration section
Hi Nakul, You can configure a nested folder structure using the Backslash '\' character, In the attached images you can see I set up the Display Folder of the columns (attributes) to…
- Shai_Ben_Ami
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: IMDB Engine and Database Questions
Hello Dave, Sorry for the late response to this post, but I hope that some of those questions are still relevant. 1. The disk size and the memory size are not the same,…
- Shai_Ben_Ami
- 5 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: IMDB - Questions about modelling
Hi Markus, 1. The IMDB called "source" (picture 3) because it is the source of the model (the model is based on that IMDB server). 2. Users can give roles only to roles that he is taking part of. 3.…
- Shai_Ben_Ami
- 5 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: How to call or execute(take as data-source) an SQL stored procedure in pyramid analytics
Hi Srilakshmi, The data discovery doesn't know how to work with stored procedures (or exec commands). Avi suggest a different solution - use the ETL to execute the store procedure,…
- Shai_Ben_Ami
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Time Intelligence Intepreting US Date when its UK Date sequence
Hi Stuart, Which type of datasource are you using in the Data Flow? All the SQL based should automatically read the date with the right format. if the problem occurred on Excel / Text file,…
- Shai_Ben_Ami
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Left/Right Outer joins
Hello, The preview table in the data modeling tool is working on the top 50 rows from the data source. There is a high probability that 50 rows from table A,…
- Shai_Ben_Ami
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Outer Joins
Hello Clement, The table header show which table is on the left side, and which one is on the right side. In your example, the EBS_ table is the left table.…
- Shai_Ben_Ami
- 6 yrs ago
- Questions & Answers
- Reported - view
Re: SQL Query in Model
Hello, When you write SQL Query on SQL Server, "select * from table1", The SQL engine will look for table1 in the dbo (default) schema. In you case, your tables are inside "pyramid" schema.…
- Shai_Ben_Ami
- 6 yrs ago
- Questions & Answers
- Reported - view
Re: Pyramid 2018 - Model Source Changes
Hi Lara, On the latest pyramid version (2018.04.233), you will be able to click on a refresh button that located on the Column Selection property card.…
- Shai_Ben_Ami
- 6 yrs ago
- Questions & Answers
- Reported - view
Re: Excel as Target in a Model
Hi Dave F., When you click on validate, the RTE try to access to the share-folder that you provide. If the user that run the RTE doesn't have write access to that share-folder,…
- Shai_Ben_Ami
- 6 yrs ago
- Questions & Answers
- Reported - view

Welcome to the Pyramid User Community

Pyramid User Community

Shai Ben Ami

Re: How to get export of Excel file which is getting used in the report.

Re: Optimizing a Star Schema Data Model

Re: Using Variables with strings in Master flow

Re: Date slicers- show months in chronological order

Re: Date slicers- show months in chronological order

Re: Date slicers- show months in chronological order

Re: Date slicers- show months in chronological order

Re: Date slicers- show months in chronological order

Re: how to create nest folder view in configuration section

Re: IMDB Engine and Database Questions

Re: IMDB - Questions about modelling

Re: How to call or execute(take as data-source) an SQL stored procedure in pyramid analytics

Re: Time Intelligence Intepreting US Date when its UK Date sequence

Re: Left/Right Outer joins

Re: Outer Joins

Re: SQL Query in Model

Re: Pyramid 2018 - Model Source Changes

Re: Excel as Target in a Model

Home