top of page
Typ
Kategorie
110 Ergebnisse gefunden für „“
- I need some help on a dynamic measure header display based on slicer selections.In Ask QuestionsOctober 19, 2023Sales Header = IF ( HASONEVALUE ( Subsidiary[Name] ), "Sales for " & VALUES ( Subsidiary[Name] ), "Total Sales" ) Cost Header = IF ( HASONEVALUE ( Subsidiary[Name] ), "Cost for " & VALUES ( Subsidiary[Name] ), "Total Cost" ) GP Header = IF ( HASONEVALUE ( Subsidiary[Name] ), "GP for " & VALUES ( Subsidiary[Name] ), "Total GP" )00
- Hi we are working on live connection which is connected through SSAS , ..In Ask QuestionsOctober 26, 2023When you're working with SQL Server Analysis Services (SSAS) and you want to extract metadata such as column names, you can use the following methods: 1. Using SQL Server Management Studio (SSMS): 1. Connect to your SSAS server instance in SSMS. 2. In the Object Explorer, expand the server, and then expand the "Databases" folder. 3. Find and expand the database that contains your cube. 4. Expand the "Cubes" folder and then expand the cube that you're interested in. 5. You should see a "Dimensions" folder. Expand this to see a list of dimensions (tables). 6. Expanding a dimension will show you the attributes (columns) of that dimension. 2. Using XMLA Queries: 1. Connect to your SSAS server instance in SSMS. 2. Open a new XMLA query window. 3. Execute the following XMLA query to get the list of dimensions and their attributes: MDSCHEMA_DIMENSIONS YourDatabaseName YourCubeName YourDatabaseName YourCubeName This will return a list of dimensions and their attributes, which you can then use to extract the column names for each table. The column names will be listed under the "ATTRIBUTE_NAME" column in the results.00
- One quick question please : Do we need to install any gateway to connect post GRE SQL database to connect to Azure.In Ask QuestionsOctober 27, 2023To connect a PostgreSQL database to Microsoft Azure services using a managed identity, you typically don't need to install a gateway. However, you need to configure your Azure service and the PostgreSQL database to allow for the connection. Here's a general approach you might consider: 1. Configure Azure Service: • In the Azure portal, navigate to the service you want to connect to your PostgreSQL database. • Go to the "Identity" panel and turn on system-assigned managed identity. • Assign necessary roles to the managed identity to allow it to interact with the database. 3. Configure PostgreSQL Database: • Ensure that the PostgreSQL database allows connections from Azure. • Add the necessary firewall rules to allow traffic from Azure. • Create the necessary database users and roles. • Grant the necessary permissions to the database users and roles. 4. Connect from Azure Service: • Use the managed identity's credentials to connect from your Azure service to the PostgreSQL database. 5. Test the Connection: • Test the connection to ensure that everything is configured correctly.00
- Are you getting Microsoft mashup engine1 error, odata version 3 and 4 error, error 404 not foundIn Tech TalkJuly 21, 2023Yes, that's correct. To connect to files stored in SharePoint using the "SharePoint Folder" connector in Power BI, you need to provide the correct URL of the SharePoint document library that contains the files you want to access. Here's how you can do it: Go to the SharePoint Document Library: In your SharePoint site, navigate to the document library that contains the files you want to connect to in Power BI. Copy the URL: Copy the URL from the address bar of your web browser. The URL should look something like this: https://your-sharepoint-site.sharepoint.com/sites/YourSiteName/Shared%20Documents/YourDocumentLibrary/ Go to Power BI Desktop: Open Power BI Desktop. Get Data from SharePoint Folder: Go to the "Home" tab and click on "Get Data." Choose "SharePoint Folder" from the list of data sources. Enter the SharePoint URL: In the "From SharePoint Folder" dialog, paste the URL you copied from your SharePoint document library into the "Folder Path" field. Click "OK." Connect to Files and Folders: Power BI will connect to the SharePoint document library and display the files and folders it contains in the Navigator window. Choose Files to Load: In the Navigator, select the files you want to load into Power BI by checking the corresponding checkboxes. You can also choose to load all files in the document library. Click "Load": Once you've selected the files you want to load, click on "Load" to load the data into your Power BI report.0
- Power BI Project End to End- HR AnalyticsIn Power BI ProjectsAugust 27, 2023If I were a candidate discussing this Power BI project in an interview, here's how I would explain each topic: 1. Data Cleaning & Processing in Power BI: In this project, we started by importing raw HR data into Power BI. Before we could visualize and analyze the data, we needed to clean and prepare it. This involved identifying and handling missing values, correcting data types, and removing duplicates. Power BI's data transformation capabilities, particularly Power Query, were used for this purpose. 2. Power BI Dashboard Setup: Once the data was cleaned and processed, we set up the foundation for our HR analytics dashboard. This included creating a new Power BI report and adding various visuals, which would collectively form the dashboard. 3. Import Data in Power BI: The next step was to import the cleaned HR data into Power BI. This involved connecting to the data source (e.g., Excel, SQL database) and loading the data into the Power BI environment. 4. Power Query in Power BI: Power Query was a crucial tool in this project. We used it to transform and shape the data further. This included merging multiple data sources, applying advanced data transformations, and creating custom columns to derive insights. 5. DAX in Power BI: DAX (Data Analysis Expressions) played a significant role in the project. We used DAX formulas to create calculated columns and measures. For instance, we could calculate metrics like employee turnover rate, average salary, or performance indexes using DAX. 6. Measures and Calculations in Power BI: Within Power BI, we defined measures and calculations using DAX. Measures are dynamic calculations that respond to user interactions and slicer selections. This allowed us to provide real-time insights based on user needs. 7. Charts in Power BI: Charts and visuals are at the heart of data visualization. We leveraged various types of charts, such as bar charts, line charts, and pie charts, to represent HR metrics visually. This made it easier for users to understand trends and patterns. 8. Filters and Slicers in Power BI: To enhance interactivity, we implemented filters and slicers in the dashboard. These tools allowed users to select specific criteria, departments, time periods, or any other relevant data points. The visuals automatically adjusted to reflect the user's selections. 9. Dashboard in Power BI: The dashboard itself was a collection of interconnected visuals, charts, and tables. It presented a comprehensive view of HR analytics, enabling users to explore and gain insights at a glance. 10. Export Power BI Dashboard - Insights from Dashboard: Users could export the dashboard or specific visuals in various formats (e.g., PDF, PowerPoint). This was helpful for sharing insights with stakeholders who might not have direct access to Power BI. The dashboard's insights provided actionable information for HR decision-making.00
- help me to making Purchases Requisition and Purchase Order in SAP. Today I bought server access but I am unable to make PR and POIn Ask QuestionsOctober 19, 2023Creating a Purchase Requisition (PR) in SAP 1. On the SAP Easy Access screen, enter transaction code ME51N and press Enter. 2. In the Purchase Requisition screen, enter the necessary details such as Document Type, Material, Quantity, Plant, etc. 3. Click on the check mark button to check for any errors. 4. If there are no errors, click the Save button to save the purchase requisition. A message will appear at the bottom of the screen with the PR number. Creating a Purchase Order (PO) in SAP 1. On the SAP Easy Access screen, enter transaction code ME21N and press Enter. 2. In the Purchase Order screen, enter the necessary details such as Document Type, Vendor, Purchasing Organization, Purchasing Group, etc. 3. In the item overview section, enter the Material, Quantity, Plant, etc. 4. Click on the check mark button to check for any errors. 5. If there are no errors, click the Save button to save the purchase order. A message will appear at the bottom of the screen with the PO number.00
- MySQL query - all combinations without duplicates or reverse order duplicatesIn Ask QuestionsSeptember 29, 2023SELECT 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 WHERE item1 != item2 AND item1 != item3 AND item1 != item4 AND item1 != item5 AND item2 != item3 AND item2 != item4 AND item2 != item5 AND item3 != item4 AND item3 != item5 AND item4 != item5 AND item1 < item2 AND item1 < item3 AND item1 < item4 AND item1 < item5 AND item2 < item3 AND item2 < item4 AND item2 < item5 AND item3 < item4 AND item3 < item5 AND item4 < item5 GROUP BY item1, item2, item3, item4, item5, concat_ws('', IFNULL(item1,''), IFNULL(item2,''), IFNULL(item3,''), IFNULL(item4,''), IFNULL(item5,''))00
- is it possible t9 do incremental refresh in power bi with monthly snapshot data ?In Ask QuestionsOctober 14, 2023To set up incremental refresh for monthly snapshot data: 1. Parameters: • In Power Query Editor, set up two date parameters: RangeStart and RangeEnd. • These parameters will be used to filter the data that gets loaded into the model. 1. Filtering: • Still in Power Query Editor, filter your history table using these parameters. For example, you might use a filter like: Date >= RangeStart and Date < RangeEnd. 1. Incremental Refresh Configuration: • Close the Power Query Editor and go to the table's properties in the Fields pane. • Configure the incremental refresh: • Set the "Store rows in the last" option to the number of months of data you want to keep in the model. For example, if you want to keep 12 months of data, set it to 12 months. • Set the "Refresh rows in the last" option to 1 month, since you're adding data monthly. • Use the RangeStart and RangeEnd parameters appropriately. 1. Publish to Power BI Service: • Incremental refresh is a feature of the Power BI Service, so you'll need to publish your .pbix file to the service. • Once published, configure the dataset's scheduled refresh. The Power BI Service will use the incremental refresh settings to only load the new month's data on each refresh. 1. Handling the Base Table: • For your requirement of making the earliest month a base table and the remaining months as incremental, you can initially set the RangeStart and RangeEnd to cover just the earliest month when you first publish the dataset. This will load only that month's data. • Subsequently, when you adjust the parameters for scheduled refresh in the Power BI Service, set them to cover all months from the earliest month to the current month. This way, the earliest month's data will remain as the base, and only new months' data will be added incrementally.00
- Welcome to the ForumIn General Discussion·July 18, 2023Share your thoughts. Feel free to add GIFs, videos, hashtags and more to your posts and comments. Get started by commenting below.002
- In Power Bi,How to get the previous day date as current date with duplicate dates.In Questions & Answers·July 20, 2023To get the previous day's date as the current date in Power BI, you can use the TODAY() function to get today's date and then subtract one day from it to get the previous day. However, as you mentioned that there are duplicate dates, you may encounter issues when using simple date arithmetic. To handle duplicate dates, you can use the following approach: Create a calendar table: First, create a separate calendar table in Power BI that includes a unique list of all dates in your dataset, including duplicates if present. Add a calculated column: In the calendar table, add a calculated column that calculates the previous day's date. You can use the EARLIER() function to refer to the current row's date in the calculation. For example, if the name of the date column in your calendar table is "Date," and you want to create a new column called "PreviousDay," use the following DAX formula: PreviousDay = VAR CurrentDate = [Date] RETURN CALCULATE( MAX('Calendar'[Date]), 'Calendar'[Date] < CurrentDate ) This DAX formula calculates the maximum date that is less than the current date for each row, effectively giving you the previous day's date. Use the new column in your visuals: Once you have the "PreviousDay" column in your calendar table, you can use it in your Power BI visuals and analyses. You can now filter data based on the previous day's date as needed By using a separate calendar table and a calculated column, you can handle duplicate dates and ensure that the previous day's date is accurately calculated, even in cases where there are duplicates. This approach provides more flexibility and control over the date calculations in Power BI.0013
- Forum rulesIn General Discussion·July 18, 2023We want everyone to get the most out of this community, so we ask that you please read and follow these guidelines: Respect each other Keep posts relevant to the forum topic No spamming007
- Introduce yourselfIn General Discussion·July 18, 2023We'd love to get to know you better. Take a moment to say hi to the community in the comments.001
bottom of page