top of page
Type
Category
110 items found for ""
- Hi sir,I have today count measure Yesterday count measureIn Ask Questions·October 26, 2023Hi sir,I have today count measure Yesterday count measure Last week same day count measure How can we show today vs yesterday Today vs yesterday vs last week same day Today vs last week same day I'n line chart I tried to create switch measure But it accepts one value to one measure Any inputs on this pls018
- I am trying to install FullStory to record sessions on SF. The script is uploaded as a static resource into SFIn Ask Questions·September 29, 2023I am trying to install FullStory to record sessions on SF. The script is uploaded as a static resource into SF, properly loaded, but then only the component that loaded it has access to it. The instalation of FullStory is very similar to most analytics tools, you just include a code snippet to your page header and it just works. However SF places it inside shadow dom and its not accessible globally, this prevents FS from capturing the screen because its not properly setup. this is how my component looks like import { LightningElement } from 'lwc'; import fsScript from "@salesforce/resourceUrl/local-fullstory"; import { loadStyle, loadScript } from "lightning/platformResourceLoader"; export default class FullStoryTest extends LightningElement { connectedCallback() { console.log("in connect " + fsScript); loadScript(this, fsScript) .then(() => { console.log("Loaded"); console.log("FS obj " + FS); // here FS object is available }).catch((err) => console.log(err)); } } } Inside I have access to FS object, but I have to be albe to access FS in the browser console once I open the page. Is there a way to achieve this in SF?016
- One quick question please : Do we need to install any gateway to connect post GRE SQL database to connect to Azure.In Ask QuestionsOctober 28, 2023Based on the video, it seems like you might not need a gateway to connect Power BI to an Azure SQL database, as they are both cloud-based services. However, you may encounter issues due to network security and firewall settings. In the example provided in the video, the user received an error because their IP address wasn't allowed to access the database. To resolve this, they added their IP address to the firewall rules, which allowed them to connect to the database. If you are experiencing a similar error, you can try the following steps: 1. Check the firewall rules of your Azure SQL database to ensure that your IP address is allowed. 2. If your organization has strict security policies, you may need to consult with your IT department or network administrator to ensure that Power BI can connect to the database. 3. As mentioned in the video, for Azure SQL databases, you can try allowing Azure services and resources to access the database. This should allow Power BI to connect to the database without the need for a gateway.0
- Are you getting Microsoft mashup engine1 error, odata version 3 and 4 error, error 404 not foundIn Tech TalkJuly 20, 2023First I need to paste correct link in SharePoint folder0
- I need some help on a dynamic measure header display based on slicer selections.In Ask Questions·October 19, 2023I need some help on a dynamic measure header display based on slicer selections. Currently, my measure header is as follows by default (without slicer selection): Total Sales Total Cost Total GP But when my slicer of subsidiary is selected (for example ABC or XYZ), i need to measure header to change accordingly to below, depending on single selection. If multiple selections then default header applies. Sales for ABC Cost for ABC GP for ABC or Sales for XYZ Cost for XYZ GP for XYZ I have seem a few number of tutorials but mostly are dealing with dynamic column headers and I have no idea how to apply to measures. Bookmarks will not help as well since it might reverse selections of other slicers. Many thanks in advance! Cheers! Regards Shao014
- Can you please tell what is the difference between Paginated report visual in power bi visual pane and Paginated reports build through ..In Ask Questions·October 19, 2023Can you please tell what is the difference between Paginated report visual in power bi visual pane and Paginated reports build through report builder?014
- Here's a more detailed set of notes based on the Erwin Data Modeler tutorial overview:In Tech Talk·September 19, 2023Erwin Data Modeler Tutorial Notes: 1. Introduction to Erwin: • Definition: Erwin Data Modeler is a tool designed for data modeling, allowing users to visually design, generate, and manage databases. • Model Types: Supports various types of data models including logical, physical, and conceptual. 2. Getting Started: • Installation: • Ensure system requirements are met. • Follow installation guidelines and enter the license key when prompted. • User Interface: • Model Explorer: Displays the structure of your model. • Diagram Window: Visual representation of your data model. • Properties Window: View and edit properties of selected objects. 3. Creating a New Model: • Steps: • Go to File > New. • Select the type of model. • For physical models, specify the target database (e.g., Oracle, SQL Server). • Save Regularly: Use File > Save to save your progress. 4. Logical Data Modeling: • Entities: • Represent data objects or things you want to track information about. • Add attributes to entities to represent data elements or fields. • Relationships: • Define connections between entities. • Set cardinality (e.g., one-to-many). • Generalization & Specialization: • Represent "is-a" relationships. • Useful for capturing inheritance in data models. 5. Physical Data Modeling: • Tables: • Equivalent to entities in logical modeling but tailored to a specific DBMS. • Add columns to represent data fields. • Indexes: • Structures to improve query performance. • Can be unique or non-unique. • Keys: • Primary Key (PK): Uniquely identifies a record. • Foreign Key (FK): Links tables together. 6. Forward & Reverse Engineering: • Forward Engineering: • Convert logical models to physical models. • Generate SQL scripts to create the database. • Reverse Engineering: • Extract structures from an existing database to create a model. • Useful for documentation or to understand legacy systems. 7. Model Validation: • Purpose: Ensure the model is consistent and free from errors. • Process: • Use Erwin's built-in validation tool. • Review and address any issues or warnings. 8. Generating Reports: • Benefits: Documentation, stakeholder communication, and review. • Formats: Erwin can generate reports in HTML, RTF, XML, etc. • Customization: Tailor reports to include specific details. 9. Model Comparisons & Merging: • Comparison: Identify differences between models or between a model and a database. • Merging: Integrate changes from one model into another. 10. Collaboration & Version Control: • Team-Based Modeling: Multiple users can work on a model simultaneously. • Version Control: Track changes, maintain versions, and manage model history. 11. Advanced Features: • Naming Standards: Ensure consistency in naming conventions. • Macro Language: Automate repetitive tasks. • User-Defined Properties (UDPs): Add custom properties to model objects.0115
- MySQL query - all combinations without duplicates or reverse order duplicatesIn Ask Questions·September 29, 2023I have a query that returns all possible combinations from 5 columns. The problem is I want to remove duplicates (Car | Car) and reserve order duplicates (Truck | Car) if (Car | Truck) already exists. I’ve played around with DISTINCT, but haven’t had any luck. Sample Data: wdt_id|column1|column2|column3|column4|column5 1|Car|Car|''|Cat|'' 2|Truck|Truck|''|Dog|'' 3|Plane|Plane|''|Bird|'' SELECT item1, item2, item3, item4, item5 ,concat_ws('',NULLIF(item1,''),NULLIF(item2,''),NULLIF(item3,''),NULLIF(item4,''),NULLIF(item5,'')) as combination FROM ( SELECT column1 AS item1 FROM sample_data ) AS t1 CROSS JOIN ( SELECT column2 AS item2 FROM sample_data ) AS t2 CROSS JOIN ( SELECT column3 AS item3 FROM sample_data ) AS t3 CROSS JOIN ( SELECT column4 AS item4 FROM sample_data ) AS t4 CROSS JOIN ( SELECT column5 AS item5 FROM sample_data ) AS t5 GROUP BY item1, item2, item3, item4, item5 ,concat_ws('',IFNULL(item1,''),IFNULL(item2,''),IFNULL(item3,''),IFNULL(item4,''),IFNULL(item5,''))013
- how to get this ' floor(weekend (today())))' in DAXIn Ask Questions·September 29, 2023how to get this ' floor(weekend (today())))' in DAX019
- Are the Ciphers ECDHE-RSA-AES128-SHA256 and ECDHE-RSA-AES256-SHA384 strong?In Ask Questions·September 29, 2023ELBSecurityPolicy-TLS13-1-2-2021-06 Once this policy is updated the server has listed below Ciphers which are supported. Preferred TLSv1.3 128 bits TLS_AES_128_GCM_SHA256 Curve 25519 DHE 253 Accepted TLSv1.3 256 bits TLS_AES_256_GCM_SHA384 Curve 25519 DHE 253 Accepted TLSv1.3 256 bits TLS_CHACHA20_POLY1305_SHA256 Curve 25519 DHE 253 Preferred TLSv1.2 128 bits ECDHE-RSA-AES128-GCM-SHA256 Curve 25519 DHE 253 Accepted TLSv1.2 128 bits ECDHE-RSA-AES128-SHA256 Curve 25519 DHE 253 Accepted TLSv1.2 256 bits ECDHE-RSA-AES256-GCM-SHA384 Curve 25519 DHE 253 Accepted TLSv1.2 256 bits ECDHE-RSA-AES256-SHA384 Curve 25519 DHE 253 Are these Ciphers strong or safe? As per my understanding from web, the GCM ones are strong Ciphers. However when I checked for others, say "ECDHE-RSA-AES128-SHA256" the search results only show "ECDHE_RSA_WITH_AES_128_CBC_SHA256". Looks like this one has vulnerabilities (Beast attack). Are these both same? Is it ok to allow "ECDHE-RSA-AES128-SHA256" and "ECDHE-RSA-AES256-SHA384" Please advise.013
- How to configure import mode for PBIRS report?In Ask Questions·September 29, 2023How to configure import mode for PBIRS report? Does power bi report server paginated report (made via report builder) support import mode?014
- Power BI Project End to End- HR AnalyticsIn Power BI Projects·August 15, 2023Topics you will be learn in this Power BI Project: - Data Cleaning & Processing in Power BI - Power BI Dashboard Setup - Import data in Power BI - Power Query in Power BI - DAX in Power BI - Measures and Calculations in Power BI - Charts in Power BI - Filters and Slicers in Power BI - Dashboard in Power BI - Export Power BI Dashboard - Insights from Dashboard Create the below dashboard in power bi desktop. You can download the datasets to practice this project.0141
bottom of page