Skip to main content
User Community
Pyramid
Help
Learn
Support
Generative BI
How to enable Javascript
Sign Up
Login
Welcome to the Pyramid User Community
Pyramid User Community
Search for answers here or
ask a question
Questions & Answers
Explore Pyramid
Product
Events & News
Latest Activity
Home
Profile
Shai Ben Ami
Pyramid Employee
Shai_Ben_Ami
Follow
Joined
17 Aug 2017
35
posts
2
likes received
0
followers
Badges
Company
Pyramid Analytics
Country
Israel
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
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
Pyramid Employee
Shai_Ben_Ami
6 yrs ago
Questions & Answers
Reported - view
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs & Webinars
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
Embedding Pyramid
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
Publish
SAP
Security
Events & News
Upcoming Events & Webinars
Getting Started
Community News
Customer Success Activities
What's New
View all topics